db={"user":[{"_id":"NT-723DD65BE100-444B-B441-2B2804ED7348","name":"AMC","uid":"NT-723DD65BE100-444B-B441-2B2804ED7348","updatedBy":"NT-723DD65BE100-444B-B441-2B2804ED7348","updatedOn":ISODate("2021-10-22"),}],"bookHistory":[{"_id":"SHNH-F10ED64A7F98-480B-8D8F-B7587594FB10","bookStocksId":"SHNC-7D60FF3D3E15-4C43-AB24-7E3EA1C0D79A","bookId":"SHN-E3AE0DB3BC7D-4214-BDAE-59140DA1F850","uid":"NT-723DD65BE100-444B-B441-2B2804ED7348","tookOn":ISODate("2021-10-31"),"dueOn":ISODate("2021-11-07"),"addedOn":ISODate("2021-10-31")}],"books":[{"_id":"SHN-E3AE0DB3BC7D-4214-BDAE-59140DA1F850","nameOfBook":"test","nameOfAuthor":"test authou","yearOfPublication":"1998","publication":"test","addedOn":ISODate("2021-10-27")}]}

db.user.aggregate([{"$lookup":{"from":"bookHistory",let:{uid:"$uid"},pipeline:[{$match:{$expr:{$eq:["$$uid","$uid"]}}},{"$lookup":{"from":"books","localField":"bookId","foreignField":"_id","as":"bookDetails"}},{"$unwind":"$bookDetails"}],"as":"bookHistory"}}])