如何根据键合并数组并总结值？

Question

I have an array something like below. I want to merge the nested array and display the totals. Here ID = 60.I want to merge this [0] and [1] depending in the ID value i.e., 60.

Array(
    [0] => Array
    (
        [ID] => 60
        [TOTAL] => 500
    )
    [1] => Array
    (
        [ID] => 60
        [TOTAL] => 600
    )
   [2] => Array
    (
        [ID] => 61
        [TOTAL] => 600
    )

   )

I tried with two for loops

foreach($result as $key=>$value){
    foreach($result as $key1 => $value1){
    // Do stuffs here
    }
}

I want the output as

Array(
     [0] => Array(
           [ID] =>60
           [TOTAL] => 1100
     )
     [1] =>Array(
           [ID] =>61
           [TOTAL] => 600
     )
  )

Answer 1

<?php

$result = Array(
     Array
    (
        'ID' => 60,
        'TOTAL' => 500
    ),
    Array
    (
        'ID' => 60,
        'TOTAL' => 600
    ),
   Array
    (
        'ID' => 61,
        'TOTAL' => 600
    )
   );

$set = [];   


foreach($result as $data){
    if(!isset($set[$data['ID']])) $set[$data['ID']] = 0;
    $set[$data['ID']] += $data['TOTAL'];
}

$result_set = [];

foreach($set as $id => $total){
    $result_set[] = [
        'ID' => $id,
        'TOTAL' => $total
    ];
}

print_r($result_set);

Demo: https://3v4l.org/NMmHC

• We store IDs as keys in our $set array and keep adding the total to it whenever we come across the same key in the foreach loop.
• In the end, we collect the results in a new array with ID and it's respective total.