mongodb aggregate.lookup()多表查询问题?

[wuli华仔]

mysql:
select pb.name
from person_base pb
left join person p on p.person_base_id = pb.id
left join institution ins on ins.id = p.institution_id
mongodb:
List list = Arrays.asList(
Aggregates.lookup("v1_block_5b179726ff2da217e05bf7bc","data_id","data_person_base_id","p"), Aggregates.project(Projections.fields(Projections.include("data_name"),Projections.excludeId()))
）
AggregateIterable<Document> mongoCollectionList = mongoDbStore.aggregate("v1_block_5b179837ff2da217e05bf7be",list);
我怎么把上面的sql语句转成正确的mongodb语句，我只能关联一张表，不能关联第二章机构表

[stacksoverflow]

参考一下
https://stackoverflow.com/questions/37086387/multiple-join-conditions-using-the-lookup-operator

[sillyboy_wang]

因为我这边也遇到了三张表互相关联，然后各种百度，各种懵逼

[程 程 程序员]

我的是关联的两张表，但是表A 关联的表B的两个字段，也没搞出来