title: MySQL joins and COUNT(*) from another table
body: <p>I have two tables: <code>groups</code> and <code>group_members</code>.</p>
  
  <p>The <code>groups</code> table contains all the information for each group, such as its ID, title, description, etc.  </p>
  
  <p>In the <code>group_members</code> table, it lists all the members who are apart of each group like this:</p>
  
  <pre><code>group_id | user_id
  1 | 100
  2 | 23
  2 | 100
  9 | 601
  </code></pre>
  
  <p>Basically, I want to list THREE groups on a page, and I only want to list groups which have MORE than four members.  Inside the <code>&lt;?php while ?&gt;</code> loop, I then want to four members who are apart of that group. I'm having no trouble listing the groups, and listing the members in another internal loop, I just cannot refine the groups so that ONLY those with more than 4 members show.</p>
  
  <p>Does anybody know how to do this? I'm sure it's with MySQL joins.</p>