ShopsN查询数据链式操作使用方法with,例如:
/** * 连表获取区 * @author 王波 * @date 2020-07-31 **/ public function prov() { return $this->belongsTo(RegionModel::class, 'prov')->bind([ 'prov_name' => 'name', ]); } /** * 获取用户默认收货地址 * @author 王波 * @date 2020-07-31 **/ public function getUserDefault(){ $field = 'id,realname,mobile,prov,city,dist,address,status'; $user_id = Session::get('user_id'); $where = []; $where[] = ['user_id','=',$user_id]; $where[] = ['status','=',1]; $where[] = ['display','=',0]; $data = UserAddressModel::where($where)->field($field) ->with(['prov']) ->find(); return $data; }