laravel 一表關聯二表,二表關聯三表,通過一表controller拿三表數據
model
一表關聯二表
public function ordercode() { return $this->hasOne(\App\Models\OrderCode::class,'id','ordercodeid'); }
二表關聯三表
public function order() { return $this->hasOne(\App\Models\Order::class,'id','orderid'); }
controller
通過一表拿三表數據
//查詢數據 $settlement = new OrderCodeSettlement(); $dataTypeContent = $settlement->with('ordercode','ordercode.order')->SettlementBusinessId($id)->paginate($pa,['*'],'page', $curt_page); //輸出 foreach ($dataTypeContent as $val) { echo $val->ordercode->order->order_no.'\n'; }