在sequelize中连接同一表并在excel中打印

const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql' // 或者其他支持的数据库类型
});

const User = sequelize.define('user', {
  id: {
    type: Sequelize.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  name: Sequelize.STRING,
  email: Sequelize.STRING
});

const ExcelJS = require('exceljs');

// 查询数据
User.findAll().then(users => {
  // 创建一个新的Excel工作簿
  const workbook = new ExcelJS.Workbook();
  const worksheet = workbook.addWorksheet('Users');

  // 添加表头
  worksheet.addRow(['ID', 'Name', 'Email']);

  // 添加数据行
  users.forEach(user => {
    worksheet.addRow([user.id, user.name, user.email]);
  });

  // 保存Excel文件
  workbook.xlsx.writeFile('users.xlsx').then(() => {
    console.log('Excel文件已保存');
  });
});