$this->db->select($value); $this->db->from('goods'); $this->db->join('category', 'category.cat_id = goods.cat_id','left'); $this->db->join('user', 'user.user_id = goods.user_id','left')->where($condition); $query = $this->db->get(); return $query->result_array();