How to get data of joined table using query() method

PHP Code:

public function showProduct(){
    $this->db->select('category.*, COALESCE(SUM(product.cost),0) as price', false)
         ->join('product', 'product.cId = category.cId')
         ->groupBy('category.cId');

    return $this;
}