根据给定的MySql数组重新排序php表行

<?php
// 连接到数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询数据并转换为PHP数组
$sql = "SELECT * FROM table_name";
$result = $conn->query($sql);

$data = array();
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $data[] = $row;
    }
}

// 根据排序规则对PHP数组进行排序
usort($data, function ($a, $b) {
    // 比较字段为 'sort_field'
    return $a['sort_field'] - $b['sort_field'];
});

// 将排序后的数据插入到新的表中
$newTableName = "new_table_name";
foreach ($data as $row) {
    $sql = "INSERT INTO $newTableName (column1, column2, column3) VALUES ('" . $row['column1'] . "', '" . $row['column2'] . "', '" . $row['column3'] . "')";
    $conn->query($sql);
}

// 关闭数据库连接
$conn->close();
?>