You could use exists
:
select e.*,
exists(
select 1
from events_attendees ea
where ea.pin_id = e.id and ea.user_id = 656
) attending
from events e
An alternative is a left join
:
select e.*, (ea.pin_id is not null) attending
from events e
left join events_attendees ea on ea.pin_id = e.id and ea.user_id = 656
CLICK HERE to find out more related problems solutions.