How to sort by one-to-many relationship?

Question

Laravel

How to sort by relationship?
The product has prices. The current price is selected based on the last one added. The price is stored as a separate Price object.

Product{
    public function prices(){
        return $this->hasMany(Price::class);
    }

    public function price(){
        return $this->prices()->orderBy('created_at', 'desc')->first();
    }
}

How to sort products by price? Sorting by selection result is not appropriate. It is necessary in the request.

Answer 1

In Laravel, you can sort by several parameters.

User::orderBy('name', 'DESC')
    ->orderBy('email', 'ASC')
    ->get();

the request itself is formed in this way.
Or join the goods by Id and sort them already by the general table.

Answer 2

$price = Price::orderBy('created_at', 'desc')->first();
$products = $price->products;