const { rows, count } = await Article.findAndCountAll({
      where,
      distinct: true,
      offset: start * pageCount,
      limit: pageCount,
      order: [
        ['created_date', 'DESC']
      ],
      include: [
        {
          model: Author,
          attributes: ['id', 'name', 'avatar'],
          as: 'authors'
        },
        {
          model: Tag,
          as: 'tags'
        },
        {
          model: Category,
          attributes: ['id', 'name'],
          as: 'category',
        },
        {
          model: Comment,
          as: 'comments',
          attributes: ['id']
        },
      ]
    })

我想在查询的时候给文章列表添加多一个comment_count的字段来记录评论数量，而不保留comments字段，比如返回：

[
	{
		id: 0,
		category: {
			id: 1,
			name: 'category'
		},
		authors: [],
		tags: [],
		comment_count: 10,
		...
	},
	...
]

我google了很久，找到以下方法，但是只能在include里只有一个comments时才有用。一旦在include里嵌套Author、Tag之类就会报错…已经花了好几个小时了，求指导

Location.findAll({
    attributes: { 
        include: [[Sequelize.fn('COUNT', Sequelize.col('comments.id')), 'comment_count']] 
    },
    include: [{
        model: Comment, as: 'comments', attributes: []
    }],
    group: ['Article.id']
})