Scope to get true or false if user subscribed to channel

I have three tables:

users (id, name)

channel (id, name)

subscription (user_id, channel_id)

Now I try to implement a scope for the Channel-Model. To this scope I pass the ID of an user.

As an output I want to get something like this:

Channel ID - Channel Name - Subscribed (True/False)

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2oTfCsy
via IFTTT