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