title: mySQL multiple columns in group concat
body: <p>I'm trying to select multiple columns from multiple tables into one single column as a string (since this is part of a larger query)</p>
  
  <p>Basically what I'm trying to do is make sub-groups of an <code>ID</code> and a <code>Name</code>, The only problem however is that I can't find a way to split these after they already have had a separator assigned to the parent group.</p>
  
  <p>My code:</p>
  
  <pre><code>SELECT 
      GROUP_CONCAT(`mytable1`.`id`, `mytable2`.`name` SEPARATOR  ', ')
  FROM `mytable1`
  INNER JOIN `mytable2`
      ON `mytable2`.`id` = `mytable1`.`id`
  </code></pre>
  
  <p>What I'm getting:</p>
  
  <pre><code>127Name, 153Name, 153Name, etc..
  </code></pre>
  
  <p>What I'm trying to achieve:</p>
  
  <pre><code>127 : Name, 153 : Name, 153 : Name, etc..
  </code></pre>
  
  <p>Is there any way this is possible?</p>