I need help with this SQL query

[eluser]Unknown[/eluser]
This does what I want:

SELECT distinct residency, count(*) as count
FROM users
WHERE (active = 1)
GROUP BY residency;

I am struggling to get this into my model. So far I have:

Code:

function get_residency()
{
        $this->db->select('residency');
        $this->db->distinct();
        $this->db->from('users');
        $this->db->where('active', '1');
        $query = $this->db->get();
        return $query->result();
}

How do I put the count as count part in??