[{"_id":ObjectId("5a934e000102030405000001"),Urls:[{IncomingUrl:"test1",status:"active"}],DraftUrls:[{IncomingUrl:"test2",status:"inactive"}]},{"_id":ObjectId("5a934e000102030405000002"),Urls:[{IncomingUrl:"test4",status:"active"}],DraftUrls:[{IncomingUrl:"test10",status:"inactive"}]},{"_id":ObjectId("5a934e000102030405000003"),Urls:[{IncomingUrl:"test55555",status:"active"}],DraftUrls:[{IncomingUrl:"test66666",status:"inactive"}]}]

db.collection.aggregate([{$match:{$or:[{"Urls.IncomingUrl":{$in:["test1","test2","test3","test4"]}},{"DraftUrls.IncomingUrl":{$in:["test1","test2","test3","test4"]}}]}},{$project:{Urls:{$map:{input:{$filter:{input:"$Urls",as:"u",cond:{$in:["$$u.IncomingUrl",["test1","test2","test3","test4"]]}}},as:"rls",in:"$$rls.IncomingUrl"}},DraftUrls:{$map:{input:{$filter:{input:"$DraftUrls",as:"du",cond:{$in:["$$du.IncomingUrl",["test1","test2","test3","test4"]]}}},as:"drls",in:"$$drls.IncomingUrl"}}}},{$project:{urls:{$concatArrays:["$DraftUrls","$Urls"]},_id:0}},{$unwind:"$urls"},{$group:{_id:null,urls:{$addToSet:"$urls"}}},{$project:{_id:0}}])