with(['user', 'vipUser'=>['user'], 'referee','orderMaster'=>['product'=>['image']]]) ->where('is_invalid', '=', 0); // 筛选用户 $user_id > 0 && $model = $model->where('user_id', '=', $user_id); // 筛选结算状态 $is_settled > -1 && $model = $model->where('is_settled', '=', $is_settled); // 获取列表数据 return $model->order(['create_time' => 'desc']) ->paginate($param); } }