如何在NodeJS中从MySQL查询中生成嵌套的JSON结果？

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

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database: ' + err.stack);
    return;
  }
  console.log('Connected to MySQL database as id ' + connection.threadId);
});

const query = 'SELECT * FROM table_name';
connection.query(query, (error, results, fields) => {
  if (error) {
    console.error('Error executing MySQL query: ' + error.stack);
    return;
  }
  
  // 处理查询结果
  const nestedJSON = generateNestedJSON(results);
  
  // 打印嵌套的JSON结果
  console.log(nestedJSON);
});

connection.end((err) => {
  if (err) {
    console.error('Error closing MySQL database connection: ' + err.stack);
    return;
  }
  console.log('MySQL database connection closed.');
});