alias('a') ->join('user user','a.user_no = user.user_no','LEFT') ->join('admin admin','admin.admin_id = a.admin_id','LEFT') ->field('a.*,user.user_name,admin.admin_name'); if(!empty($condition)){ $this->where($condition); } if(!empty($order)){ $this->order($order); } if($is_count){ return $this->count(); } return $this->page($page,$pageSize)->select(); } }