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';
}