Node mysql2子承诺/子查询并将结果追加到json对象

const mysql = require('mysql2/promise');

async function getNestedData() {
  try {
    const connection = await mysql.createConnection({
      host: 'localhost',
      user: 'root',
      password: 'password',
      database: 'mydatabase'
    });

    const [rows, fields] = await connection.execute('SELECT * FROM table1 WHERE column1 = ?', ['value1']);

    const jsonData = {
      data: rows
    };

    // Perform subquery
    const [subRows, subFields] = await connection.execute('SELECT * FROM table2 WHERE column2 = ?', ['value2']);

    jsonData.subData = subRows;

    console.log(jsonData);

    connection.end();
  } catch (error) {
    console.error(error);
  }
}

getNestedData();