How to make a selection of users through the model, except for users with certain emails (like a black list)?

Question

Laravel

Good afternoon. There is a selection of all users, then they receive emails. And there is a table of emails (like a blacklist), to which nothing needs to be sent. Is it possible to make eloquent without bicycles so that it selects all users, except for those whose emails are on this black list? If so, how.

Answer 1

WHERE NOT IN method will help you

Answer 2

Adding a relationship to the blacklist table to the User model

public function blackEmail()
{
    return $this->hasOne('App\Models\BlackEmail', 'email', 'email');
}

And we use it everywhere

User::doesntHave('blackEmail')
    ->get();

or add a boolean has_black_email field to the users table

User::where('has_black_email', false)
    ->get();