with('A') ->join('user B', 'B.user_id=A.user_id', 'left') ->field(['A.user_id,B.avatarUrl,B.nickName,B.real_name,B.mobile,B.create_time']); if (isset($params['search']) && $params['search'] != '') { $model = $model->where('B.nickName|B.mobile,B.real_name', 'like', '%' . trim($params['search']) . '%'); } return $model->where('A.branch_id', '=', $branch_id)->where('A.is_delete', '=', 0) ->paginate($params); } }