title: MYSQL combine multiple rows into single row using join with another table
body: <p>I want to join a table with another table but i need multiple row values from second table.</p>
  
  <p>Table #1:(orders)</p>
  
  <pre><code>userid  order_id
  
  1412    1412_AD_150910
  1413    1413_AD_150910 
  </code></pre>
  
  <p>Table #2:(follow_up)</p>
  
  <pre><code>userid date    comments        called
  
  1412   150910   test comments    1
  1412   150911   comments1        0
  1413   150912   test             1
  </code></pre>
  
  <p>Results will be like this:</p>
  
  <pre><code>userid  order_id         follow_up_details
  
  1412    1412_AD_150910   [{150910,testcomments,1},{150911,comments1,0}]
  1413    1413_AD_150910   [{150912,test,1}]
  </code></pre>
  
  <p>Basically i want to combine rows from second table using userid.</p>
  
  <p>Thanks in advance.</p>