Need help with Eloquent data model/relationships or query statement

What do u want to get? its not clear yet for me.

When a user is authenticated, I want to pass the reservationtimes to the view for the accounts associated to the authenticated user.

I see, I'll think for a while, honestly I'd think a way with Native SQL

@stephen_p In my experience, pivot tables are not used for hasMany/belongsTo relationships. I think a hasManyThrough relationship between User and Schedule would get you most of the way there.

On User:

public function schedules()
{
    $this->hasManyThrough(Schedule::class, Account::class);
}

I'm not sure this will work with your table structure though. Unless there's a specific reason you're using pivot tables, you might try:

1. Dumping the pivot tables
2. Add a user_id (integer) column on acccounts
3. Add an account_id (integer) column on schedules.

Then:

user-->hasMany-->account

user-->hasManyThrough-->schedule

account-->belongsTo-->user

account-->hasMany-->schedule

schedule-->belongsTo-->account

Then you could $user->schedules(). .....or something like that. :)

Thanks for the reply. I came across this yesterday in the Laravel documentation, but resisted because I didn't want to be locked into the account->belongsTo->User inverse relationship. Sorry, I should have put the inverse relationships in my original post.

The purpose for the pivot table is to leave the flexibility for many-to-many "accounts->has many->users" relationship.

I would lose this relationship for user #2 to infinity for any given account.

Is there a way to do the hasManyThrough a many-to-many relationship? Or something comparable?