如何为Node.js返回多个sql表？

const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 连接数据库
connection.connect();

// 编写SQL查询
const sql = `
  SELECT * FROM table1;
  SELECT * FROM table2;
`;

// 执行查询
connection.query(sql, (error, results, fields) => {
  if (error) throw error;

  // 处理结果
  const table1Data = results[0];
  const table2Data = results[1];

  // 返回结果
  const responseData = {
    table1: table1Data,
    table2: table2Data
  };

  // 发送响应
  res.json(responseData);
});

// 关闭数据库连接
connection.end();