Is it possible to add a condition on the number of child records in whereDoesntHave?

Question

Laravel

Hello,
Can you please tell me if it is possible to select records in which the number of child records is less than or equal to 1 using whereDoesntHave?

$room = Room::whereDoesntHave('bookings', function($query) use ($request) {
        $query->where('end', '>=', $request->start_date);
        $query->where('start', '<=', $request->end_date);
    }
);

I need for the booking system to select all rooms in which no more than one person lives in a given period of time.
That is, we need whereDoesntHave with count < 2
Thanks!

Answer 1

Room::whereHas('bookings', function($query) use ($request) {
    $query->where('end', '>=', $request->start_date);
    $query->where('start', '<=', $request->end_date);
}, '<=', 1)->get();