$ordersDay = $user->orders()
->selectRaw('status, count() as count')
->where('orders.created_at', '>', Carbon::today())
->groupByRaw('status')
->get();
//вот так работает но нужно получить orders которые привязаны к определенному user
$ordersDay = DB::table('orders')
->selectRaw('status, count(*) as count')
->where('orders.created_at', '>', Carbon::today())
->groupByRaw('status')
->get();
//Model User
class User extends Authenticatable
{
public function orders(): HasManyThrough
{
return $this->hasManyThrough(Order::class,
Customer::class);
}
}