Laravel得到多对多的范围

Question

I want to filter all my users who ordered amount of orders in range so

User::where('type','client')
->whereHas('orders',function ($query) use($min_orders,$max_orders){

})

any solution??

Answer 1

You could use has() filter to filter out users with min and max count of associated orders

User::where('type','client')
    ->has('orders', '>=', $min_orders)
    ->has('orders', '<=', $max_orders)
    ->get()

See Querying Relationship Existence