mysql对象转数组方法

<?php
$mysqli = new mysqli("localhost", "username", "password", "database");

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

$sql = "SELECT id, name FROM users";
$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        print_r($row);
    }
} else {
    echo "0 结果";
}
$mysqli->close();
?>

import pymysql

connection = pymysql.connect(host='localhost',
                             user='username',
                             password='password',
                             db='database')

try:
    with connection.cursor() as cursor:
        sql = "SELECT id, name FROM users"
        cursor.execute(sql)
        result = cursor.fetchall()
        array_result = [list(item) for item in result]
        print(array_result)
finally:
    connection.close()

const mysql = require('mysql');

const connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'username',
  password : 'password',
  database : 'database'
});

connection.connect();

connection.query('SELECT id, name FROM users', (error, results, fields) => {
  if (error) throw error;
  const arrayResult = results.map(result => Object.values(result));
  console.log(arrayResult);
});

connection.end();