如何在PHP MYSQL中显示一个月内基于日期的列循环数据？

$start_date = date('Y-m-d');
$end_date = date('Y-m-d', strtotime('+1 month'));

$date_range = array();
$current_date = $start_date;

while ($current_date <= $end_date) {
    $date_range[] = $current_date;
    $current_date = date('Y-m-d', strtotime($current_date . ' +1 day'));
}

$query = "SELECT * FROM your_table WHERE date_column BETWEEN '$start_date' AND '$end_date'";
$result = mysqli_query($connection, $query);

echo '<table>';
echo '<tr><th>Date</th><th>Data</th></tr>';

while ($row = mysqli_fetch_assoc($result)) {
    echo '<tr>';
    echo '<td>' . $row['date_column'] . '</td>';

    foreach ($date_range as $date) {
        if ($row['date_column'] == $date) {
            echo '<td>' . $row['data_column'] . '</td>';
        } else {
            echo '<td></td>';
        }
    }

    echo '</tr>';
}

echo '</table>';