使用join仅从Sequelize.js返回所需的列

const { Sequelize, Model, DataTypes } = require('sequelize');

// 创建Sequelize实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql',
});

// 定义模型
const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING,
    allowNull: false,
  },
  age: {
    type: DataTypes.INTEGER,
    allowNull: false,
  },
});

const Order = sequelize.define('Order', {
  amount: {
    type: DataTypes.FLOAT,
    allowNull: false,
  },
});

// 建立关联关系
User.hasMany(Order);
Order.belongsTo(User);

// 查询数据并返回所需的列
User.findAll({
  attributes: ['name'], // 返回name列
  include: [{
    model: Order,
    attributes: ['amount'], // 返回amount列
  }],
}).then(users => {
  console.log(users);
}).catch(error => {
  console.error(error);
});