JOOQ:如何将外键解析为对象？

// 定义外键关系
ForeignKey<Record, ?> foreignKey = DSL.constraint("fk_author_book")
        .foreignKey(AUTHOR.BOOK_ID)
        .references(BOOK.ID);

// 查询外键关联的对象
Result<Record> result = create.select()
        .from(AUTHOR)
        .join(BOOK).on(foreignKey)
        .fetch();

// 解析查询结果为对象
List<Author> authors = result.stream()
        .map(record -> {
            Author author = new Author();
            author.setId(record.get(AUTHOR.ID));
            author.setName(record.get(AUTHOR.NAME));
            // 解析关联的书籍对象
            Book book = new Book();
            book.setId(record.get(BOOK.ID));
            book.setTitle(record.get(BOOK.TITLE));
            author.setBook(book);
            return author;
        })
        .collect(Collectors.toList());