title: Codeigniter active record select, left join, count
body: <p>I have a form that shows results from a database query, these results can have many other assets ajoined to them and I wanting to find a way of showing how many assets each elemement has.  For example my table is of areas of england an other table has where the users live I current have this code, </p>
  
  <pre><code>$this-&gt;db-&gt;select('*');
  $this-&gt;db-&gt;from('places');
  $this-&gt;db-&gt;join('users, places.place_id = user.place_id, left');
  
  $this-&gt;db-&gt;get();
  </code></pre>
  
  <p>The issue I am having is getting the query to return the place name and the number of users living in that place, it is possible?</p>