title: Mysql join tables for menu and submenu
body: <p>I've been working on this new project and I need help about this situation.
  I have sql database with two tables: menu and submenu.</p>
  <p>The structure of tables is :</p>
  <blockquote>
  <p>Menu : id | title | order</p>
  <p>Submenu : id | title | parentId</p>
  </blockquote>
  <p>When I want to generate menu item and submenu item below I use two simple query, is there any simplier way with joining table.Basically I want this :</p>
  <ol>
  <li><p>Menu Item</p>
  <pre><code>+ Submenu Item 1
  + Submenu Item 2
  + Submenu Item 3
  </code></pre>
  </li>
  <li><p>Menu Item</p>
  <pre><code>+ Submenu Item 1
  + Submenu Item 2
  + Submenu Item 3
  </code></pre>
  </li>
  </ol>