Laravel Eloquent getting all 'with' relationship without specifying one by one

Question

My relationships is something like:

player
   sub
       something
   sub-2
   sub-3
       something
           foobar
   sub-4

I can get player by id with its sub like this:

Player::with('sub.something','sub-2','sub-3.something.foobar','sub-4')->find($id);

However I had to specify each 'with' relationship manually. Is it possible to just get everything on the child relationship (hasMany/hasOne) in one query? Something like:

Player::with(everything())->find($id);

if you define what 'everything' is ... the model does not know what methods are relationship methods ... so sure if you wanted to create some method/macro that adds all those withs to a builder you could easily do it — lagbox

apokryfos apokryfos · Accepted Answer · 2018-08-14T06:14:42

The short answer is no, relationships are expensive to get so you need to be explicit with what you need to load each time. You can however specify which relationships are always eager loaded on the model:

class Player extends Model {
    protected $with = [ 'sub.something','sub-2','sub-3.something.foobar','sub-4' ];
    // Rest of model
}

This way you won't need to specify ::with every time when loading a model.

Laravel Eloquent getting all 'with' relationship without specifying one by one

3 Answers