Database

[{director:"James",category:"fruit",name:"apple",money:5000},{director:"James",category:"toy",name:"dragon",money:15000},{director:"Sam",category:"fruit",name:"orange",money:3500}]

Query

db.collection.aggregate([{$facet:{directorList:[{$group:{_id:"$director",money:{$sum:"$money"}}},{"$project":{"_id":false,"director":"$_id","money":1}}],categoryList:[{$group:{_id:"$category",money:{$sum:"$money"}}},{"$project":{"_id":false,"category":"$_id","money":1}}]}}])

Result