How to make such a selection by links?

Question

Laravel

Greetings! It would seem a simple thing, but I can not get the result.
There are models:
User - hasMany - Room
Room - hasMany - Order
How to get all relationships of a Room, with one last Order entry?
Tried to do like this:

$user->rooms()
    ->with([ 'orders' => function ($query) {
         $query->with('user')->latest()->first();
         }
    ])
->get();

I also tried instead of first() ->take(1)->get()
But I get only one record only for the first connection, and the rest are empty:

[
            0 => [
                'orders' => ['name order']
            ],
            1 => [
                'orders' => []
            ],
            2 => [
                'orders' => []
            ],
        ]

How to get only one record from a link?

Answer 1

It is easier to implement the lastOrder relation in the Room model.

public function lastOrder(): HasOne
{
    return $this->hasOne(Order::class, '...')->latest();
}

And in the selection just use
->with('lastOrder')