How to build query to get data from DB with Elequent ORM?

Question

Laravel

How to write a query for a selection, for example, through if I can select the records that I need, but at the same time I then get all the records from the database and compare and send the
necessary ones through a loop.

$user = User::find($user_id);
        $messages =  Message::where('active', true)->get();
if($message->referrer == true || $message->referrer == false && $user->referrer_1_id == null){

And how can you already write if in a
query
?

Answer 1

https://laravel.com/docs/9.x/queries#conditional-c...
something like

Message::where('active', true)
  ->when($user->referrer_1_id !== null, function ($query, $userReferrerIsNotNull) {
    $query->where('referrer ', true);
  })->get()

Answer 2

I don't know what kind of perversion to use when.
like this, you can configure it as you like and just do pass the request anywhere in the variable.

$user = User::find($user_id);
$messagesQuery =  Message::where('active', true);
if($message->referrer == true || ($message->referrer == false && $user->referrer_1_id == null)){
  $messagesQuery->where(....);
}
$messages =  $messagesQuery->get()

Answer 3

$response = User::where([
    ['active', true],
    ['referrer', true],
])->orWhere([
    ['active', true],
    ['referrer', false],
])->whereHas('user', function ($q) {
    $q->where('referrer_1_id', null);
})->get();

Street Magic