当我使用.fetchAll({ withRelated: 'backfire' });时，我在输出中得到了一个名为backfire的属性，其值为{}。在knex调试模式下，我清楚地看到select "backfire".* from "backfire" where "backfire"."id" in (?);在复制/粘贴到sqlite3控制台时工作（当然是在输入有效ID之后）。所以我知道我的模型一定是正确的。

Knex迁移

exports.up = function(knex, Promise) {
  return knex.schema.createTable("backfire", function(table) {
    table.increments("id").primary();
    table.string("response").notNullable();
    table.string("created_by").notNullable();
    table.timestamps();
}).then(function(){
        return knex.schema.createTable("backfireTrigger", function(table) {
            table.increments("id").primary();
            table.string("trigger").notNullable();
            table.integer("backfire_id").unsigned().notNullable().references("id").inTable("backfire");
            table.string("created_by").notNullable();
            table.timestamps();
        });
    });
};

Models.js

module.exports = function(bookshelf) {

var Backfire = bookshelf.Model.extend({
    tableName: 'backfire',
    backfireTriggers: function() {
      return this.hasMany(BackfireTrigger);
    }
});

var BackfireTrigger = bookshelf.Model.extend({
    tableName: 'backfireTrigger',
    backfire: function() {
      return this.belongsTo(Backfire);
    }
});

return {
  Backfire: Backfire,
  BackfireTrigger: BackfireTrigger
};

}

我的用法

function getAllTriggers() {
    var self = this;
    return new self.models.BackfireTrigger()
    .fetchAll({
        withRelated: ['backfire']
    });
}