title: How create json format with group-concat mysql?
body: <p>How create json format with group-concat mysql?</p>
  
  <p>(I use MySQL)</p>
  
  <p>Example1:</p>
  
  <p>table1:</p>
  
  <pre><code>email            |    name  |   phone
  -------------------------------------
  my1@gmail.com    | Ben      | 6555333
  my2@gmail.com    | Tom      | 2322452
  my2@gmail.com    | Dan      | 8768768
  my1@gmail.com    | Joi      | 3434356
  </code></pre>
  
  <p>like syntax code that not give me the format: </p>
  
  <pre class="lang-sql prettyprint-override"><code>select email, group-concat(name,phone) as list from table1 
  group by email
  </code></pre>
  
  <p>output that I need:</p>
  
  <pre><code>email         |    list
  ------------------------------------------------
  my1@gmail.com |  {name:"Ben",phone:"6555333"},{name:"Joi",phone:"3434356"}
  my2@gmail.com |  {name:"Tom",phone:"2322452"},{name:"Dan",phone:"8768768"}
  </code></pre>
  
  <p>Thanks</p>