$query = DB::table('permissions as p')
->leftJoin(
'role_has_permissions as rhp',
function($q) use ($key) {
$q->on('p.id', '=', 'rhp.permission_id')
->where('rhp.role_id', '=', $key);
})
->whereNull('rhp.permission_id');
İle çözüm buldum. Role atanmamış yetkilerin listesini istiyordum. Ürettiği sorgu şu şekilde;
select
*
from "permissions" as "p"
left join "role_has_permissions" as "rhp" on "p"."id" = "rhp"."role_id"
and "rhp"."role_id" = '649cc3a4-ab0e-4649-b3cd-a86755e31506'
where
"rhp"."permission_id" is null