[{"appId":"1","targetFrom":"a","targetTo":"b","date":"2022-01-14"},{"appId":"1","targetFrom":"b","targetTo":"c","date":"2022-01-17"},{"appId":"1","targetFrom":"x","targetTo":"y","date":"2021-12-24"}]

db.collection.aggregate({$match:{$expr:{$and:[{$eq:["$appId","1"]},{$and:[{$gte:["$date","2022-01-01"]},{$lt:["$date","2022-01-31"]}]},{$or:[{$in:["$targetFrom",["a","c","x"]]},{$in:["$targetTo",["a","c","x"]]}]}]}}})