Is it possible to create a custom link?

Question

Laravel

For example, instead of this, in the Order model

public function order
{
    return $this->belongsTo('App\Order');
}

Something like

public function order
{
    return self::query()->where('cost',  '>',  $this->cost);
}

The example is purely hypothetical. The task is to work with my request, as if with an attitude. Use with, withCount etc

Answer 1

I solved the issue by implementing a custom method that adds a link to the collection of models.
Transmitted in a completely different way

public function relatedOrders()
    {
        return $this->hasMany(self::class, "parent_id", "id")->fromHighPriceOrders();
    }

And everything will work great. Through subqueries for each order, we find the id of orders with a higher price, and make joion of such orders. Then we bind) surprisingly fast

Answer 2

I think I understand...
Reading about scope's

public function scopeCost($query,$value)
    {
        return $query->where('cost', '>', $value);
    }

$data = Order::cost(100)->get();