Database

db={"countries":[{"countryId":1,"Countryname":"India","movieId":11,},{"countryId":2,"Countryname":"India","movieId":13,},{"countryId":3,"Countryname":"China","movieId":12,},{"countryId":4,"Countryname":"Japan","movieId":14,},],"movies":[{"MovieId":11,"title":"Movie 11","description":"Description 11",},{"MovieId":12,"title":"Movie 12","description":"Description 12",},{"MovieId":13,"title":"Movie 13","description":"Description 13",},{"MovieId":14,"title":"Movie 14","description":"Description 14",},{"MovieId":15,"title":"Movie 15","description":"Description 15",},]}

Query

db.countries.aggregate([{"$lookup":{"from":"movies","localField":"movieId","foreignField":"MovieId","as":"data"}},{$unwind:"$data"},{$replaceRoot:{newRoot:{$mergeObjects:["$data","$$ROOT"]}}},{$project:{data:0}},{$match:{Countryname:{"$in":["India","China"]}}}])

Result