Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

royvarghese's avatar

Laravel 6.14 Convert a raw sql query to laravel query builder

SELECT * FROM events LEFT JOIN user_events ON events.id = user_events.event_id AND user_events.user_id = 1;

Please help me to convert this query to Laravel query builder

0 likes
3 replies
MThomas's avatar

What did you try yourself, what was the result/error? What do you models look like etc.

royvarghese's avatar

i have to fetch all the data from events table out of all these events some of the events are subscribed so i have to get all the events and the events user got subscribed

events.id => primary key user_events.event_id => events table foreign key

krishantalwar's avatar

$users = DB::table('events') ->leftJoin('user_events', 'events.id', '=', 'user_events.events_id') ->where('events..user_id', '=', 5); ->get();

Please or to participate in this conversation.