Laravel query with with and where?

Question

Laravel

And how could one get data when: there is an order and it has many offers, you need to get all orders with the search status and if it has offers with user_id == Auth::id() . It seems like you can’t just do it through where and with

$orders = Order::where('status', 'search')
            ->with([
                'offers' => function ($q) {
                    $q->where('user_id', Auth()->id())->first();
                }
            ])->get();

order is required, and offers is either empty, or it contains one offer (required) . And it turns out that once again one where must be done separately with a check for non-null in offers for each order ??

Answer 1

google whereHas

Answer 2

I would use ::where(....)->joinLeft(....)->select('orders.*' , 'offers.* as offer')->get();
select is needed so that the id field of offers does not replace the id field of the orders table