如何使用sequelize-hierarchy在Node.js中对同一级别的项目进行排序？

npm install sequelize sequelize-hierarchy

const Sequelize = require('sequelize');
const Hierarchy = require('sequelize-hierarchy');

const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql' // 根据实际情况选择数据库类型
});

const Project = sequelize.define('Project', {
  name: Sequelize.STRING
});

Hierarchy.applyTo(Project, {
  as: 'hierarchy',
  through: 'ProjectHierarchy',
  levelFieldName: 'level',
  foreignKey: 'parentId',
  onDelete: 'CASCADE'
});

Project.findAll({
  order: [
    [sequelize.col('hierarchy.level')],
    [sequelize.col('hierarchy.sequence')]
  ]
}).then(projects => {
  console.log(projects);
}).catch(err => {
  console.error(err);
});