laravel eloquent like mysql left join with where condition [duplicate]

  laravel, mysql, php
SELECT * FROM nav_subs LEFT JOIN 
(SELECT * FROM nav_accesses WHERE user_id = 3) AS navaccess ON navaccess.sub_id = nav_subs.id 
WHERE user_id IS null;

Source: Ask PHP

LEAVE A COMMENT