limit에 대해 질문드립니다.

const profilePosts = await User.findOne({
      where: { id: userId },
      attributes: [],
      include: [
        {
          model: Post,
          include: [
            {
              model: User,
              attributes: ["id", "nickname", "department", "avatar"],
            },
            {
              model: User,
              as: "PostLikeUsers",
              attributes: ["id"],
            },
            {
              model: Comment,
              attributes: ["id"],
            },
          ],
        },
      ],
    });

include 안에서 Post model에 limit을 두고 싶습니다.

예를 들어, Post model에 16개의 게시글이 저장되어 있으면 5개만 불러오고 싶습니다.

어떻게 하면 될까요?

시도했던 방법

1.

 include: [
        {
          model: Post,
          limit: 5,
          subQuery: false, 
          include: [
            {
              model: User,
              attributes: ["id", "nickname", "department", "avatar"],
            },
            {
              model: User,
              as: "PostLikeUsers",
              attributes: ["id"],
            },
            {
              model: Comment,
              attributes: ["id"],
            },
          ],
        },
      ],

2.

include: [
        {
          model: Post,
          attributes: ["id", "UserId"],
          separate: true,
          limit: 5,
          include: [
            {
              model: User,
              attributes: ["id", "nickname", "department", "avatar"],
            },
            {
              model: User,
              as: "PostLikeUsers",
              attributes: ["id"],
            },
            {
              model: Comment,
              attributes: ["id"],
            },
          ],
        },
      ],

module.exports = (sequelize, DataTypes) => {
  const User = sequelize.define(
    "User",
    {
      email: {
        type: DataTypes.STRING(30),
        allowNull: false,
        unique: "email",
      },
      name: {
        type: DataTypes.STRING(30),
        allowNull: false,
      },
      nickname: {
        type: DataTypes.STRING(30),
        allowNull: false,
        unique: "nickname",
      },
      department: {
        type: DataTypes.STRING(30),
        allowNull: false,
      },
      avatar: {
        type: DataTypes.TEXT,
      },
    },
    {
      charset: "utf8",
      collate: "utf8_general_ci",
    }
  );

User.associate = (db) => {
    db.User.hasMany(db.Post);
  };
}

module.exports = (sequelize, DataTypes) => {
  const Post = sequelize.define(
    "Post",
    {
      type: {
        type: DataTypes.STRING(30),
        allowNull: false,
      },
      title: {
        type: DataTypes.TEXT,
        allowNull: false,
      },
      content: {
        type: DataTypes.TEXT,
        allowNull: false,
      },
      views: {
        type: DataTypes.INTEGER,
        defaultValue: 0,
      },
    },
    {
      charset: "utf8mb4",
      collate: "utf8mb4_general_ci",
    }
  );

Post.associate = (db) => {
    db.Post.belongsTo(db.User);
  };
}