Nested With() in Laravel Model Collection Return

Question

I have a collection that is returned as such:

$scheduleLoads = Load::with('shipment','driver','tractor');

Now, my question is related to the with issue - is there a way to add the relationships of these relationships into my returned collection?

For example:

In the Load model I have the following relationship to shipment:

public function shipment(){
    return $this->belongsTo(shipment::class, 'shipmentID');
}

In the shipment model I have the following relationship:

public function shiptoAccount(){
    return $this->belongsTo('App\Customer', 'ship_to');
}

Is there a way to include the shiptoAccount return of the shipment associated with the Loads collections?

Do you mean Load::with('shipment.shiptoAccount','driver','tractor');? — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Sep 1, 2018 at 2:05
I'll add this above, but my relationship to the shipment is as such from my Load model: public function shipment(){ return $this->belongsTo(shipment::class, 'shipmentID'); } — jHannel
– jHannel, Commented Sep 1, 2018 at 2:11
Wow, that made me feel a bit a bit dull... thank you so much! I was curious, just for future reference, how would I include another? Would I have to go out and write 'shipment.shiptoAccount','shipment.shipfromAccount', ... or some other way? — jHannel
– jHannel, Commented Sep 1, 2018 at 2:16
Yes, exactly like that. laravel.com/docs/5.6/eloquent-relationships#eager-loading — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Sep 1, 2018 at 2:17

Jonas Staudenmeir · Accepted Answer · 2018-09-01 02:23:26Z

1

Use the "dot" syntax (documentation):

$scheduleLoads = Load::with('shipment.shiptoAccount', 'driver', 'tractor');

answered Sep 1, 2018 at 2:23

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1