在PHP代码中对变量/数组创建SELECT SUM() GROUP BY查询的等价物？

$data = array(
    array('group' => 'A', 'value' => 10),
    array('group' => 'B', 'value' => 20),
    array('group' => 'A', 'value' => 30),
    array('group' => 'B', 'value' => 40),
);

$result = array();

foreach ($data as $item) {
    $group = $item['group'];
    $value = $item['value'];

    if (!isset($result[$group])) {
        $result[$group] = 0;
    }

    $result[$group] += $value;
}

print_r($result);

Array
(
    [A] => 40
    [B] => 60
)