如何在反应式 PostgreSQL、Quarkus 中查询包含另一个对象的对象

Question

我有一个类 RetailPlace，其数据放置在 Retail_place 表中，还有 RetailPlaceAddress 类，其数据放置在 Retail_place_address 表中。通过retail_place.id = Retail_place_address.retail_place_id连接retail_place和retail_place_address。我需要创建一个返回带有 RetailPlaceAddress 的 RetailPlace 对象的方法。 我尝试先获取 RetailPlaceAddress，然后将其放入接下来获取的 RetailPlace 对象中，但它不起作用：

    public static Uni<RetailPlace> get(PgPool client, long id){

    return client.preparedQuery("select * from retail_place_address where retail_place_id = $1")
            .execute().onItem().transform(RowSet::iterator)
            .onItem().transform(iterator -> iterator.hasNext() ? RetailPlaceAddress.from(iterator.next()) : null).onItem()
            .transform(retailPlaceAddress -> new RetailPlace(client.preparedQuery("select * from retail_place where id = $1").execute()
                    .onItem().transform(pgRowSet -> new RetailPlace(pgRowSet.iterator().next().getLong("id"), pgRowSet.iterator().next().getString("title"), retailPlaceAddress))));
}