如何在迭代使用mysqli_use_result返回的行时执行mysqli查询？(PHP)

$connection = mysqli_connect("localhost", "username", "password", "database");
if (!$connection) {
    die("连接数据库失败：" . mysqli_connect_error());
}

$query = "SELECT * FROM table";
$result = mysqli_query($connection, $query);
if (!$result) {
    die("查询失败：" . mysqli_error($connection));
}

$resultSet = mysqli_use_result($connection);
if (!$resultSet) {
    die("获取结果集失败：" . mysqli_error($connection));
}

while ($row = mysqli_fetch_assoc($resultSet)) {
    // 执行操作，例如打印每行的数据
    echo "ID: " . $row['id'] . ", Name: " . $row['name'] . "<br>";
}

mysqli_free_result($resultSet);

$connection = mysqli_connect("localhost", "username", "password", "database");
if (!$connection) {
    die("连接数据库失败：" . mysqli_connect_error());
}

$query = "SELECT * FROM table";
$result = mysqli_query($connection, $query);
if (!$result) {
    die("查询失败：" . mysqli_error($connection));
}

$resultSet = mysqli_use_result($connection);
if (!$resultSet) {
    die("获取结果集失败：" . mysqli_error($connection));
}

while ($row = mysqli_fetch_assoc($resultSet)) {
    // 执行操作，例如打印每行的数据
    echo "ID: " . $row['id'] . ", Name: " . $row['name'] . "<br>";
}

mysqli_free_result($resultSet);
mysqli_close($connection);