#laravel #whereHas

laravel whereHas

// result WHERE foreignKey = X AND (first_name = Y OR last_name = Z)

bookings=$bookings->whereHas('client',function($q) use ($client_name){
    $q->where( function ($q) use ($client_name) {
        $q->where('first_name','LIKE',$client_name)
            ->orWhere('last_name','LIKE',$client_name);
    });
});