laravel 6
$customers = Customer::addSelect(['balance' => CustomerBalance::selectRaw('sum(amount) as total')
->whereColumn('customer_id', 'customers.id')
->groupBy('customer_id')
])
->orderBy('balance', 'DESC')
->get()
->toArray();
dd($customers);
laravel 5
$customers = User::select("*", \DB::raw('(SELECT SUM(amount) FROM customer_balances WHERE customer_balances.customer_id = customers.id) as balance'))
->orderBy('balance', 'DESC')
->get()
->toArray();
dd($customers);
标签: laravel
顶一下
(0)
0%
踩一下
(0)
0%