MatteoOreficeIT/LaravelQueryJoinRelations.php

class A extends Model {
    public function relatesB() { return $this->belongsTo( B::class ); }
}

class B extends Model {
    public function relatesC() { return $this->belongsTo( C::class ); }
}

class C extends Model {
    public function relatesD() { return $this->belongsTo( D::class ); }
}

class C extends Model { }

\App\A::query()
    // include every available aliases from different join clause
    ->select('A.*','B.*','C.*','D.*')
    ->joinWith(
        // specify relations join order/path for consecutive / nested relations
        ['relatesB','relatesC','relatesD'],
        // place an alias for every related model, remember in reverse order
        // you can also use only ['D'] and so the other aliases will be generated appendind a number for example D_1,D_2, ..., D_N
        ['D','C','B','A']
     );

$query->select('A.field1 as relationB.field1')  /// you will find in result a key [ 'relationB.field1' => 'valueOfField1OnModelB' ]

        $relationValues = [];
        collect($model->getAttributes())->each(function($value,$name)use(&$relationValues,$model){
            if(Str::contains($name,'.')) {
                Arr::set($relationValues,$name,$value);
                unset($model[$name]);
            }
        });
        collect($relationValues)->each(function($value, $name)use(&$model){
           $model[$name] = $value;
        });