Database

db={"Account":[{"_id":{"$oid":"6348dc197a7b552660170d8b"},"username":"12345","password":"123dsgfdsgdfsg","email":"1243","role":"123","_infoid":{"$oid":"6348dc197a7b552660170d8a"}}],"Information":[{"_id":{"$oid":"6348dc197a7b552660170d8a"},"avatar":"hello","name":"Abcd","phonenumber":"012345678","address":"abcd"}]}

Query

db.Information.aggregate([{"$lookup":{"from":"Account","localField":"_id","foreignField":"_infoid","pipeline":[{"$project":{role:1}}],"as":"AccountLookup"}},{"$unwind":"$AccountLookup"},{$set:{phonenumber:"$AccountLookup.role"}},{$unset:"AccountLookup"},{"$merge":{"into":"Information","on":"_id","whenMatched":"merge","whenNotMatched":"discard"}}])

Result