alias('reg') ->field('reg.*, user.nickName, user.avatarUrl') ->join('user', 'user.user_id = reg.user_id') ->where('reg.is_delete', '=', 0) ->order(['reg.create_time' => 'desc']); // 查询条件 if (!empty($search)) { $model = $model->where('user.nickName|reg.user_name|reg.mobile', 'like', '%' . $search . '%'); } if (!empty($activity_id)) { $model = $model->where('reg.activity_id', '=', $activity_id); } // 获取列表数据 $list = $model->paginate($limit); return $list; } /** * 删除报名用户 * @return mixed */ public function setDelete() { return $this->transaction(function () { // 标记用户记录为已删除 return $this->save([ 'is_delete' => 1 ]); }); } }