[{product_id:"123",variant_id:"000"},{product_id:"123",variant_id:"111"},{product_id:"987",variant_id:"000"}]

db.collection.find({$or:[{"product_id":"123","variant_id":"000"},{"product_id":"987","variant_id":"000"}]})