Sequelize:如何根据关联表的列之和查询父列

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

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

// 定义父表模型
class Parent extends Model {}
Parent.init({
  parent_column: DataTypes.INTEGER
}, { sequelize, modelName: 'parent' });

// 定义子表模型
class Child extends Model {}
Child.init({
  child_column: DataTypes.INTEGER
}, { sequelize, modelName: 'child' });

// 建立父子表之间的关联关系
Parent.hasMany(Child, { foreignKey: 'parent_id' });
Child.belongsTo(Parent, { foreignKey: 'parent_id' });

// 查询父表的parent_column列，根据子表的child_column列之和
Parent.findAll({
  attributes: ['parent_column', [sequelize.fn('SUM', sequelize.col('child.child_column')), 'child_column_sum']],
  include: [{
    model: Child,
    attributes: []
  }],
  group: ['parent.id']
}).then(parents => {
  console.log(parents);
}).catch(error => {
  console.error(error);
});