Database
[{"user_id":"2328292073","username":"Bob","subscriptions":[{"id":"38271281","payments":[{"id":"00001","amount":"1900"},{"id":"00002","amount":"2000"},{"id":"00003","amount":"3000"}]}]}]
Query
db.collection.find({"user_id":"2328292073","subscriptions.id":"38271281"},{payments:{$reduce:{input:"$subscriptions",initialValue:[],in:{$cond:[{$eq:["$$this.id","38271281"]},"$$this.payments","$$value"]}}}})