where条件需要有明确那张表 ``` $where = array( 'a.store_id' => $storeId, 'a.goods_user\_status' => 1, ); $goodsRes = Db('goods') ->alias('a') ->join('goods_class b','a.class_id = b.class_id','LEFT')//商品分类 ->join('store_class c','a.store_class_id = c.class_id','LEFT')//店铺分类，在个人店铺里的 ->field('a.* , b.class_name, c.class_name as store_class_name') ->where($where) ->order('goods_id desc') ->paginate(10); ``` thinkphp实现多表查询 ``` /** * 显示资源列表 * * @return \think\Response */ public function index() { //获取当前店铺id $uid = session('home_uid'); $storeId = db('store')->where('store_uid',$uid)->field('store_uid')->find(); $storeId = implode(" ",$storeId); $storeId = (int)$storeId; $where = array( 'a.store_id' => $storeId, 'a.goods_user_status' => 1, ); //全部商品 $goodsRes = Db('goods') ->alias('a') ->join('goods_class b','a.class_id = b.class_id','LEFT')//商品分类 ->join('store_class c','a.store_class_id = c.class_id','LEFT')//店铺分类，在个人店铺里的 ->field('a.* , b.class_name, c.class_name as store_class_name') ->where($where) ->order('goods_id desc') ->paginate(10); $this->assign([ 'seo_title'=> '店铺商品-' . config('site.WEB_TITLE'), 'seo_keywords'=> config('site.WEB_KEYWORDS'), 'seo_desc'=> config('site.WEB_DESCRIPTION'), 'goodsRes' => $goodsRes, ]); return $this->fetch('seller_goods/index'); } ```