Join or Left Join only with where condition in laravel 6

Laravel eloquent join with condition