CodeIgniter - Active Record class join
$this->db->join('film_category', 'film.film_id = film_category.film_id');

$this->db->where('film_category.category_id',1);

$query = $this->db->get('film');

$result=$query->num_rows();

return $result;