[{category_id:12006000,category:"Community",details:null,euConversion:null,subCategory:"Disabled Persons Services",type:"Place",usConversione:null},{category_id:13000000,category:"Food and Drink",details:null,euConversion:0.23,subCategory:null,type:"Place",usConversione:0.18},{category_id:13001001,category:"Food and Drink",details:"Wine Bar",euConversion:0.35,subCategory:"Bar",type:"Place",usConversione:0.333},{category_id:13004004,category:"Food and Drink",details:"Jazz and Blues Cafe",euConversion:null,subCategory:"Nightlife",type:"Place",usConversione:null},{category_id:13005004,category:"Food and Drink",details:"Thai",euConversion:0.34,subCategory:"Restaurants",type:"Place",usConversione:0.267},{category_id:12008006,category:"Community",details:"Dance Schools",euConversion:0.24,subCategory:"Education",type:"Place",usConversione:0.199},{category_id:12008000,category:"Community",details:null,euConversion:null,subCategory:"Education",type:"Place",usConversione:null},{category_id:12008007,category:"Community",details:"Culinary Lessons and Schools",euConversion:0.24,subCategory:"Education",type:"Place",usConversione:0.199},{category_id:13005015,category:"Food and Drink",details:"Mexican",euConversion:0.34,subCategory:"Restaurants",type:"Place",usConversione:0.267},{category_id:13005016,category:"Food and Drink",details:"Mediterranean",euConversion:0.34,subCategory:"Restaurants",type:"Place",usConversione:0.267},]

db.collection.aggregate([{"$match":{"category":{"$ne":null},"subCategory":{"$ne":null}}},{$group:{_id:{cat:"$category",sub:"$subCategory",},docs:{$push:"$$ROOT"}}},{$group:{_id:"$_id.cat",subCategories:{$push:{subCategory:"$_id.sub",types:"$docs"}}}},])