title: GROUP_CONCAT && left outer join on 1 table?
body: <p>I've got 1 table with Menu labels in it.I need with a query to get Parent label and UnderMenu label.when i execute this:</p>
  
  <pre><code>  SELECT es.Label MenuLabel, m.Label UnderLabel 
    FROM books_menu es
    LEFT JOIN books_menu m ON es.ID = m.MenuParentID 
    WHERE es.ParentID =1 
    AND m.Type='under'
    AND es.Type='main' 
    LIMIT 0 , 30
  </code></pre>
  
  <p>everything is OK but MenuLabel show on every record.Something like this:</p>
  
  <pre><code>  MenuLabel    UnderLabel
    Home         1
    Home         2
    Home         3
    Contacts     4
  </code></pre>
  
  <p>When i execute :</p>
  
  <pre><code>  SELECT es.Label MenuLabel, GROUP_CONCAT(m.Label) AS UnderLabel 
    FROM books_menu es
    LEFT JOIN books_menu m ON es.ID = m.MenuParentID 
    WHERE es.ParentID =1 
    AND m.Type='under'
    AND es.Type='main' 
    LIMIT 0 , 30
  </code></pre>
  
  <p>i get:</p>
  
  <pre><code>      MenuLabel    UnderLabel
         Home         1,2,3,4
  </code></pre>
  
  <p>How can i get this:</p>
  
  <pre><code>   MenuLabel    UnderLabel
     Home         1,2,3
     Contacts     4
  </code></pre>
  
  <p>Thank you:)</p>