[{"_id":ObjectId("5b5c3afbcc43cb5ed64b7a04"),"id":15015060,"name":"1801_Conf","type":2,"members":[{"id":15015061,"name":"1801_Conf-W--","sku":"1801_new","type":1,"parent_id":15015060,"available_qty":10,"on_hand_qty":10,"outgoing_qty":0,"incoming_qty":0,"shortage_qty":0,"product_warehouses":[{"warehouse_id":3,"available_qty":10,"outgoing_qty":0,"incoming_qty":0},{"warehouse_id":4,"available_qty":600,"outgoing_qty":0,"incoming_qty":0}],}]}]

db.collection.aggregate([{"$project":{"members":{"$filter":{"input":{"$map":{"input":"$members","as":"member","in":{"id":"$$member.id","name":"$$member.name","sku":"$$member.id","type":"$$member.type","parent_id":"$$member.parent_id","available_qty":"$$member.available_qty","on_hand_qty":"$$member.on_hand_qty","outgoing_qty":"$$member.outgoing_qty","incoming_qty":"$$member.incoming_qty","shortage_qty":"$$member.shortage_qty","product_warehouses":{"$filter":{"input":"$$member.product_warehouses","as":"product","cond":{"$or":[{"$lt":["$$product.available_qty",50]},{"$gt":["$$product.available_qty",20]}]}}}}}},"as":"member","cond":{"$or":[{"$lt":["$$member.available_qty",50]},{"$gt":["$$member.available_qty",10]}]}}}}},{"$match":{"members":{"$ne":[]}}}])