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->reduce( function($result, $row) { static $amts = []; if (!isset($amts[$row['arrival_date']])) { $amts[$row['arrival_date']] = $row; $result[] =& $amts[$row['arrival_date']]; } else { $amts[$row['arrival_date']]['total_amount'] += $row['total_amount']; } return $result; } ) );