title: sql group by not showing all results
body: <p>So i have a query with gets all users, and all user_items. But when i group by user.id it only shows 1 item. When i remove the group it shows all the items but repeats the info.</p>
  
  <p>i want it like this</p>
  
  <pre><code>Dan | Laptop
        Car
        Bike
        Shed
  
  Mik | Computer
        House
  </code></pre>
  
  <p>This is the sql</p>
  
  <pre><code>SELECT items.name, users.username
  FROM users
  INNER JOIN items
  ON items.userid = users.id
  GROUP BY users.id
  </code></pre>