where('user.user_name|user.real_name', 'like', "%{$params['username']}%"); } $model = $model->where('log.shop_supplier_id', '=', $shop_supplier_id); // 查询列表数据 return $model->alias('log')->field(['log.*','user.user_name','user.real_name']) ->join('supplier_user user', 'user.supplier_user_id = log.supplier_user_id','left') ->order(['log.create_time' => 'desc']) ->paginate($params); } }