$this->db->select('c.category_name, count(p.product_id)'); $this->db->from('tbl_product p'); $this->db->join('tbl_categroy c','p.categroy_id = c.category_id ','left'); $this->db->group_by('c.category_id'); $query = $this->db->get(); // SELECT c.category_name, count(p.product_id) // FROM tbl_product p // JOIN tbl_category c ON p.category_id = c.category_id // group by c.category_id