title: Count multiple columns with unique value
body: <p>Table A:</p>
  <pre><code>id        name        desc
  --------------------------------
  1        abc        something
  
  2        xyz        something
  </code></pre>
  <p>Table B:</p>
  <pre><code>id        nameB        descB        tableA(fk)
  -----------------------------------------------
  1        ghj        something          1
  
  2        jkl        somethingxyz       1
  
  3        sdf        somesdf            2
  
  4        dfg        somedfg            2
  </code></pre>
  <p>I was able to produce output like</p>
  <p>TableA.name   TableB.name - Count(TableB.name)</p>
  <pre><code>abc              ghj - 1
  abc              jkl - 1
  xyz              sdf - 1
  xyz              dfg - 1
  </code></pre>
  <p>But i want something like this</p>
  <p>TableA.name   TableB.name - Count(TableB.name)</p>
  <pre><code>abc              ghj - 1, jkl - 1
  xyz              sdf - 1, dfg - 1 
  </code></pre>
  <p>1 is count</p>
  <p>Pls help with mysql query.</p>