laravel 6

$ customers=customer : add select([' balance '=customerbank rance :3360 electraw(' sum(amount ))为总计)

-哪里列(' customer_id '，' customers.id ')

-groupBy('customer_id ')

])

-orderBy('balance '，' DESC ')

-get()

-to array()；

DD(美元客户);

laravel 5

$ customers=user :3360 SELECT(' *，\ db :3360 raw(' SELECT SUM(amount)FROM customer _ balances WHERE customer _ balances .客户id=客户。id)作为余额)

-orderBy('balance '，' DESC ')

-get()

-to array()；

DD(美元客户);