PHP と Vue.js を通じてグループ化と分類の統計グラフ効果を実現する方法

$data = [
    ['group' => 'A', 'category' => 'cat1', 'amount' => 100],
    ['group' => 'A', 'category' => 'cat1', 'amount' => 150],
    ['group' => 'A', 'category' => 'cat2', 'amount' => 200],
    ['group' => 'B', 'category' => 'cat2', 'amount' => 300],
    ['group' => 'B', 'category' => 'cat1', 'amount' => 180],
    ['group' => 'C', 'category' => 'cat1', 'amount' => 120],
    ['group' => 'C', 'category' => 'cat2', 'amount' => 250],
];

$groupedData = array();

foreach($data as $row) {
    $group = $row['group'];
    $category = $row['category'];
    $amount = $row['amount'];

    if(!isset($groupedData[$group])) {
        $groupedData[$group] = array();
    }

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

    $groupedData[$group][$category] += $amount;
}

echo json_encode($groupedData);

<div id="app">
    <div v-for="(groupData, group) in groupedData" :key="group">
        <h3>{{ group }}</h3>
        <table>
            <tr v-for="(amount, category) in groupData" :key="category">
                <td>{{ category }}</td>
                <td>{{ amount }}</td>
            </tr>
        </table>
    </div>
</div>

new Vue({
    el: '#app',
    data: {
        groupedData: [],
    },
    mounted() {
        axios.get('/api/data.php')
            .then(response => {
                this.groupedData = response.data;
            })
            .catch(error => {
                console.log(error);
            });
    },
});