如何在php中创建透视数组

$data = array(
    array('name' => 'John', 'category' => 'A', 'value' => 10),
    array('name' => 'John', 'category' => 'B', 'value' => 20),
    array('name' => 'Jane', 'category' => 'A', 'value' => 15),
    array('name' => 'Jane', 'category' => 'B', 'value' => 25),
);

$pivot = array();

foreach ($data as $row) {
    $name = $row['name'];
    $category = $row['category'];
    $value = $row['value'];
    
    if (!isset($pivot[$name])) {
        $pivot[$name] = array();
    }
    
    if (!isset($pivot[$name][$category])) {
        $pivot[$name][$category] = 0;
    }
    
    $pivot[$name][$category] += $value;
}

foreach ($pivot as $name => $categories) {
    echo "Name: $name\n";
    
    foreach ($categories as $category => $value) {
        echo "Category: $category, Value: $value\n";
    }
    
    echo "\n";
}