Database

[{"a":[{"p":[{"pid":{"CC":"A","SN":"1","KC":"B"}}]}]}]

Query

db.collection.find({"a.p.pid":{"CC":"A","KC":"B","SN":{"$in":["1","2","3"]}}})

Result