Convert mysql query to laravel?

Question

MySQL

there is a mysql query

SELECT *
                FROM `rooms`
        WHERE `hotel_id` = $hotel_id
        WHERE `people` = $people
        WHERE `id` NOT IN (
                    SELECT `room_id`
                FROM `orders`
                WHERE `hotel_id` = $hotel_id
                WHERE `date_from` < $date_to AND `date_to` > $date_from

how to write it in laravel?

пробую так, но какой-то бред

$rooms = DB::table('rooms')
                        ->where('hotel_id','=', $request->hotel_id)
                        ->where('people','=', $request->people)
                        ->whereNotIn('id',DB::raw('SELECT `room_id`
                            FROM `orders`
                            WHERE `hotel_id` = '.$request->hotel_id.'
                            WHERE `date_from` < '.$to.' AND `date_to` > '.$from.''))
                        ->orderBy('rooms.id', 'asc')->get();

Answer 1

First link on google:
https://www.itsolutionstuff.com/post/laravel-5-whe...
Dock:
https://laravel.com/docs/6.x/queries#where-exists-...
PS: And by the way, this query can be easily rewritten without any subqueries using a simpleleft join