[{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}}},{"$project":{"_id":0,"category":1,"subCategory":1,"type":1,"usConversione":1,"euConversion":1,"details":1}},{"$group":{"_id":{"category":"$category","subCategory":"$subCategory","type":"$type","details":"$details","euConversion":"$euConversion","usConversione":"$usConversione"}}},{"$group":{"_id":"$_id.category","subCategory":{"$addToSet":{"subCategory":"$_id.subCategory","details":"$_id.details","euConversion":"$_id.euConversion","usConversione":"$_id.usConversione","type":"$_id.type"}}}},{"$unwind":{"path":"$subCategory"}},{"$match":{"subCategory.subCategory":{"$ne":null}}},{"$sort":{"subCategory.subCategory":1}},{"$group":{"_id":"$_id","subCategories":{"$push":"$subCategory"}}},{"$sort":{"_id":1}}])