我有以下代码使用sequelize和mySQL数据库编写：

return await SelectedEmployees.findAndCountAll({
    attributes: ['organization_id'],
    include: [
      {
        model: User,
        as: 'user',
        attributes: ['id', [sequelize.literal(`CONCAT(user.first_name, ' ', user.last_name)`), 'name'], 'email'],
        where: {
          'email': {
            [Op.like]: `%${search}%`
          }
        }

      }
    ],
    where: {
      courseId: course_id,
    },
  });

通过上面的代码，我得到了如下的响应：

{
  "count": 3,
  "rows": [
    {
      "organization_id": 101023,
      "user": [
        {
          "id": 1,
          "name": "User One",
          "email": "userOne@email.com"
        }
      ]
    },
    {
      "organization_id": 101023,
      "user": [
        {
          "id": 2,
          "name": "User Two",
          "email": "userTwo@email.com"
        }
      ]
    },
    {
      "organization_id": 957256,
      "user": [
        {
          "id": 3,
          "name": "User Three",
          "email": "userThree@email.com"
        }
      ]
    }
  ]
}

但是，可以看到，对于每个user对象，它是作为对象数组返回的，而不仅仅是返回一个对象。我的目标是简化对象并得到以下输出：

{
  "count": 3,
  "rows": [
    {
      "organization_id": 101023,
      "id": 1,
      "name": "User One",
      "email": "userOne@email.com"
    },
    {
      "organization_id": 101023,
      "id": 2,
      "name": "User Two",
      "email": "userTwo@email.com"
    },
    {
      "organization_id": 957256,
      "id": 3,
      "name": "User Three",
      "email": "userThree@email.com"
    }
  ]
}

我尝试使用raw: true和nest: true，但得到的结果略有不同，id，name和email字段位于user对象下面，如下所示：

{
      "organization_id": 101023,
      "user": {
        "id": 1,
        "name": "User One",
        "email": "userOne@email.com"
      }
    },