CODE EXAMPLE FOR PHP

laravel select where with total sum query to get all data with sum

$query =  SalesPayment::select('*', DB::raw('SUM(amount) AS total_sale_amount')->with ....