PHPize Online / SQLize Online  /  SQLtest Online

<?php $arrival_data = collect([ [ "arrival_date" => "09-Dec-2020", "total_amount" => "10", "total_traveller" => 6 ], [ "arrival_date" => "09-Dec-2020", "total_amount" => "20", "total_traveller" => 6 ], [ "arrival_date" => "10-Dec-2020", "total_amount" => "40", "total_traveller" => 3 ] ]); var_export( $arrival_data ->groupBy('arrival_date') ->map(fn($row) => collect($row->first())->put('total_amount', $row->sum('total_amount'))) ->values() ->toArray() );