How to do orderBy on related table?

Question

MySQL

There are 2 tables:
- Products (HasMany Variants)
- Product Variants (linked via variant.product_id)

$products = Product::where('products.visible', 1)
  ->whereHas('variants', function ($query) {
    $query->where('visible', 1);
  })->orderBy('id', 'asc')
  ->paginate($products_per_page);

How to do orderBy on related table?
You need to sort the products by the lowest price option

Answer 1

https://gist.github.com/Ellrion/5d873fc8acf4d18464...