Retrieving multiple emails addresses for single contact on table join

[eluser]Andy UK[/eluser]
Here's my active record query which currently only returns a single email per contact:

Code:

$this->db->select("contacts.id,
       contacts.first_name as name,
       contacts.last_name as surname,
       contact_emails.email,
       contacts.tel,
       contacts.cel,
       contacts.added_on,
       contacts.notes as client_summary,
       contacts.rating,
       client_source_types.source_label,
       status_types.status_es as status,
       status_types.color as color,
       admins.first_name as broker_first_name,
       admins.last_name as broker_last_name,
       added_by_admin.first_name as added_by_name,
       added_by_admin.last_name as added_by_surname")
    ->join('contact_emails', 'contacts.id = contact_emails.contact_id', 'left')
    ->join('status_types', 'contacts.status_id = status_types.id', 'left')
    ->join('client_source_types', 'contacts.client_source_id = client_source_types.id', 'left')
    ->join('admins', 'contacts.taken_by_id = admins.id', 'left')
    ->join('admins as added_by_admin', 'contacts.added_by = added_by_admin.id', 'left')
    ->where('contacts.id', $relationship_id);
  $query = $this->db->get('contacts');