一个数组计算问题

Question

$userlist = [                
                ['name'=>'zhang','money'=>10, 'level'=>1],
                ['name'=>'wang', 'money'=>20, 'level'=>2],
                ['name'=>'li',   'money'=>10, 'level'=>3],
                ['name'=>'zhao', 'money'=>30, 'level'=>3],
                ['name'=>'wu',   'money'=>20, 'level'=>5]
            ];

怎么按level分组统计出，money的值，顺序输出来。

level相同的，money累加起来。例如level=3的，money=10+30=40，userlist数组长度未知。

Answer 1

    $level = [];
    
    foreach ($userlist as $value) {
        $level[$value['level']] += $value['money'];
    }
    
    var_dump ($level);

结果

array(4) {
  [1] =>
  int(10)
  [2] =>
  int(20)
  [3] =>
  int(40)
  [5] =>
  int(20)
}

Answer 2

$userlist = [                
                ['name'=>'zhang','money'=>10, 'level'=>1],
                ['name'=>'wang', 'money'=>20, 'level'=>2],
                ['name'=>'li',   'money'=>10, 'level'=>3],
                ['name'=>'zhao', 'money'=>30, 'level'=>3],
                ['name'=>'wu',   'money'=>20, 'level'=>5]
            ];


function groupby($array, $groupby_key, $sum_key){
    $res = array();
    foreach($array as $data) {
        if(!array_key_exists($data[$groupby_key], $res))
            $res[ $data[$groupby_key] ] = 0;
        $res[ $data[$groupby_key] ] += $data[$sum_key];
    }
    return $res;
}


$res = groupby($userlist, 'level', 'money');
var_dump($res);

将会输出

array(4) {   
  [1]=>      
  int(10)    
  [2]=>      
  int(20)    
  [3]=>      
  int(40)    
  [5]=>      
  int(20)    
}            

Answer 3

这种问题不用考虑那么多吧， 用个foreach就好了如: @CrazyCodes 的就好.
或者考虑用array_reduce.

$result = array_reduce($userlist, function($res, $item){
        $res[$item['level']] += $item['money'];
        return $res;
}, []);