Laravel - retrieve direct/indirect pivot table subscribers

Vote count:

0

I am having a hard time figuring this out in laravel; for a subscriber relationship we have 2 pivot tables:

A subscriber can subscribe to a question:

question_subscriber
id   question_id  subscriber_id
1        2            3
2        2            4
3        3            1
4        3            2

A subscriber can subscribe to a user:

user_subscriber
id  user_id  subscriber_id
1      1         6
2      1         7
3      2         1

Normal questions table with question owner:

questions
id  question  user_id
1     abc?       1
2     xyz?       1
3     123?       2

The pivot relationships are setup correctly in their models, and I can pull out with a foreach, subscribers for a question, $question->subscribersQuestion as $subscriber, or subscribers for a user, $user->subscribersUser as $subscriber:

But how can I pull out all subscribers that belong to a user (directly or indirectly (through a question they own))?

For example, these should be all retrieved subscribers for user 1:

6 // subscribed to directly
7 // subscribed to directly
3 // subscribed to through question
4 // subscribed to through question

Any idea on the most efficient way to do this in Laravel?

asked 31 secs ago

Wonka

162

Laravel - retrieve direct/indirect pivot table subscribers