使用嵌套select with orderBy时Knex查询错误未定义的列

const knex = require('knex')({
  client: 'mysql', // 或者你使用的数据库客户端
  connection: {
    host: '127.0.0.1',
    user: 'your_database_user',
    password: 'your_database_password',
    database: 'myapp_test'
  }
});

knex.select('users.id', 'users.name')
  .from('users')
  .orderBy('users.name')
  .then(rows => {
    console.log(rows);
  })
  .catch(err => {
    console.error(err);
  });

knex.select('users.id', 'users.name')
  .from('users')
  .select(knex.raw('COUNT(orders.id) as order_count'))
  .leftJoin('orders', 'users.id', 'orders.user_id')
  .groupBy('users.id', 'users.name')
  .orderBy('order_count', 'desc')
  .then(rows => {
    console.log(rows);
  })
  .catch(err => {
    console.error(err);
  });