title: Query Returning One Row in MySQL
body: <p>When I run the following query, I only get the first row:</p>
  
  <pre><code>SELECT 
  u.name AS Firstname, u.lastname AS Lastname, count( DISTINCT(p.id) ) AS Count
  FROM
  projects p
  INNER JOIN users u ON p.user_fk = u.id
  order by user_fk;
  </code></pre>
  
  <p>I have two tables, Projects and Users and the project table has a user ID which I am using to get the name from the users table. I then want to see how many unique projects there are for each user and display the amount of projects each user has.</p>