Laravel correct whereHas?

Question

Laravel

Hello, there is a database of entities groups, they have tags, you need to make a selection of all entities that either have no tags at all or have tags, except for the excluded ones

$entities = Entity::whereHas('tags', function($query) use ($excluded) {
    $query->whereNotIn('tags.id', $excluded);
});

Here it turns out that we take entities that have tags in addition to those excluded, but if the entity has no tags at all, then they also need to be selected. Can this be done without join?

Answer 1

orWhereIsNull can be added

Answer 2

$entities = Entity::where(function($q) use ($excluded){
    $q->whereHas('tags', function($query) use ($excluded) {
        $query->whereNotIn('tags.id', $excluded);
    })->orWhereDoesntHave('tags');
});