## 一對一關聯 field選擇字段 ``` ~~~ public function seo(){ return $this->hasOne('Seo','id','seo_id')->field('id,title,status'); } ~~~ ```  bind綁定關聯表的屬性到父模型屬性 ``` ~~~ public function seo(){ return $this->hasOne('Seo','id','seo_id')->bind(['title']); } ~~~ ```  # 一對多關聯 ``` ~~~ public function seo(){ return $this->hasMany('Seo','p_id','id'); } ~~~ ```  # 關聯查詢 ``` ~~~ ~~~ if(!empty($data['title'])){ $map[] = ['title','like',"%{$data['title']}%"]; } ~~~ $this->model->with('seo')->haswhere('seo',$map)->where($where)->select(); ~~~ ```   ~~~ # 模型關聯查詢數據 ~~~ $query = (new UserCommissionLog)->alias('c')->where(['customer_id' => config('sys.platform_id')]) // 收益類型 金額 賬戶余額 粉絲手機號 時間 來源 狀態 應用類型 ->field('c.id, c.user_id, c.user_grade, c.amount, c.after_amount, c.create_time, c.order_type, c.status, c.app_type') ->whereIn('c.user_id', $user_ids) ->when(key_exists('status', $params), function (Query $query) use ($params) { $query->where(['c.status' => $params['status']]); }) ->when(key_exists('user_grade', $params), function (Query $query) use ($params) { $query->where(['c.user_grade' => $params['user_grade']]); }) ->when(key_exists('create_time', $params), function (Query $query) use ($params) { $tmpTime = explode(' - ', $params['create_time']); $query->whereBetween('c.create_time', [@$tmpTime[0], @$tmpTime[1]]); }) ->when(key_exists('mobile', $params), function (Query $query) use ($params) { $query->leftJoin('user u', 'u.id=c.user_id')->where(['u.mobile' => $params['mobile']]); }) ->with(['user' => function(Query $query) { $query->field('id, mobile'); }]) ->order('c.id desc')->paginate($this->limit); ~~~ # 模型關聯 ``` ~~~ $data = $this->model->where(['id' => $id]) ->field('id, order_no, status, user_id, create_time, pay_time, pay_type, deliver_time, express_no, username, mobile, province, city, area, location, remarks, service_remarks') ->where(['customer_id' => config('sys.platform_id')]) ->with(['user' => function (Query $query) { $query->field('id, nickname, mobile'); }, 'order_details' => function (Query $query) { $query->field('goods_order_id, goods_image, goods_name, goods_code, goods_price, goods_num, goods_total_price, discount_price, freight_price, goods_total_price, real_price'); }]) ->find(); ~~~ ~~~ public function user(): HasOne { return $this->hasOne(User::class, 'id', 'user_id'); } public function orderDetails(): HasMany { return $this->hasMany(GoodsOrderDetail::class, 'goods_order_id'); } ~~~ ```