How to daisy-chain Relationships with Logic?

You have to use whereHas, something like this :

$users = User::whereHas('events', function ($q) {
    $q->where('state_id', '=', 3);
    $q->whereHas('dates', function ($sq) {
        $sq->where('ends_at', '>', $now = new Carbon);
    });
})->get();

I didnt understand what do you want to retrieve with this query ? Users ? Events ?

Sorry for not being clear.

With this query, I wanted to retrieve the dates of an event, of a user.

Thank you @bestmomo I will give this a try.

If you need events and dates you need to eager load them :

$users = User::with('events.dates')
    ->whereHas('events', function ($q) {
    $q->where('state_id', '=', 3);
    $q->whereHas('dates', function ($sq) {
        $sq->where('ends_at', '>', $now = new Carbon);
    });
})->get();

Isn't it rather Carbon::now() for date ?

With this set up you cant retrieve dates from an user as there is no direct relationship between them.

But why not :

// Here you get the user's events and eager load their dates
$events = Auth::user()->events()->where('status',3)->with('dates')->whereHas(function($q)
{
  $q->where('ends_at', '>', Carbon::now());
})->get();

Then

@foreach($events as $event)
  @foreach($event->dates as $date)
    {{ $date->ends_at }}
  @endforeach
@endforeach

I love you all

Thank you!

Also, whilst both answers I would consider "best answers", I'm selecting pmall's, but I'd select you both if I could!