CI框架的连表查询

$this->db->select('Goods.id,Goods.title,goods.cate_id,goodscategory.cname');//查询的字段

$this->db->where(array("Goods.id"=>69,'goodscategory.cname'=>'123'));//查询的条件

$this->db->from('Goods');//连表的主表

$this->db->join('goodscategory',' goodscategory.id =  Goods.cate_id' ,'left');//连接表

$query = $this->db->get()->result_array();//语句查询，切记->result_array()；必须的有

echo json_encode($query);die;//打印语句