Laravel Eloquent Relationship Sub-Relationship?

Question

I have an Offer class with the following relationship:

class Offer extends Model
{
    public function releases()
    {
        return $this->belongsToMany('App\Release');
    }
}

The Release class has this relationship:

class Release extends Model
{
    public function artist()
    {
        return $this->belongsTo('App\Artist');
    }
}

What is the simplest way of amending

   App\Offer::with('releases')->get();

So as to also get Artist information in each release?

Answer 1

You can do this by:

App\Offer::with('releases.artist')->get();

You can look at: http://laravel.com/docs/5.1/eloquent-relationships#querying-relations for more information.

If you have multiple releations you can query them by doing:

App\Offer::with(['releases.artist', 'releases.albums'])->get();

When you scrolldown a bit you see

// Retrieve all posts that have at least one comment with votes...
$posts = Post::has('comments.votes')->get();

Remember the "dot" notations is a standard convention of Laravel. For example loading a view:

view('folder.viewfile');

The same applies to eloquents nested relationships.