Sequelize:如何对包含的第三级模型进行计数

const User = sequelize.define('User', {
  // User模型的属性定义
});

const Post = sequelize.define('Post', {
  // Post模型的属性定义
});

const Comment = sequelize.define('Comment', {
  // Comment模型的属性定义
});

User.hasMany(Post);
Post.belongsTo(User);

Post.hasMany(Comment);
Comment.belongsTo(Post);

User.findAll({
  include: [
    {
      model: Post,
      include: [
        {
          model: Comment,
          attributes: [[sequelize.fn('COUNT', sequelize.col('Comments.id')), 'commentCount']]
        }
      ]
    }
  ]
}).then(users => {
  // 处理查询结果
});

User.findAll({
  include: [
    {
      model: Post,
      include: [
        {
          model: Comment,
          attributes: [[sequelize.fn('COUNT', sequelize.col('Comments.id')), 'commentCount']]
        }
      ]
    }
  ]
}).then(users => {
  users.forEach(user => {
    user.Posts.forEach(post => {
      console.log(`用户${user.id}的帖子${post.id}有${post.Comments[0].get('commentCount')}条评论`);
    });
  });
});