$shop_sql= Shop::find()
->select("shop.id,shop.name,shop.user_id,company_user.phone,user.user_name")
->where($shop_where)
->leftJoin('shop_user', 'shop_user.shop_id=shop.id')
->leftJoin('user_center.user_info as user', 'user.id=shop_user.device_id')
->leftJoin('company_user', 'company_user.id=shop.user_id')->createCommand()->getRawSql();
Yii2打印sql语句的写法
最新推荐文章于 2020-05-02 12:39:34 发布