Database

[{"_id":{"$oid":"5f30f4f746107e12fd939a1c"},"ean":"5051892219518","productName":"Mortal Kombat 11 Premium Edition","lowestPrice":990,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Playstation","subSubCategory":"Spel","__v":0},{"_id":{"$oid":"5f30f4f746107e12fd939a1e"},"ean":"4020628721930","productName":"F1 2020 Deluxe Schumacher Edition","lowestPrice":849,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Playstation","subSubCategory":"Spel","__v":0},{"_id":{"$oid":"5f30f4f746107e12fd939a20"},"ean":"8057168500578","productName":"MotoGP 20","lowestPrice":699,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Playstation","subSubCategory":"Spel","__v":0},{"_id":{"$oid":"5f30f4f746107e12fd939a22"},"ean":"3391892003635","productName":"Dark Souls Trilogy","lowestPrice":599,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Playstation","subSubCategory":"Spel","__v":0},{"_id":{"$oid":"5f30f4f746107e12fd939ab8"},"ean":"5099206075207","productName":"Astro A50 Wireless Headset (PC / Xbox One)","lowestPrice":2595,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Xbox","subSubCategory":"Tillbehör","__v":0},{"_id":{"$oid":"5f30f4f746107e12fd939aba"},"productName":"Razer Thresher Ultimate - Xbox One (Fyndvara - Klass 1)","lowestPrice":2239,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Xbox","subSubCategory":"Tillbehör","__v":0},{"_id":{"$oid":"5f30f4f746107e12fd939abc"},"productName":"Astro A40 TR + MixAmp Pro TR - Vit (Xbox One) (Fyndvara - Klass 1)","lowestPrice":1815,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Xbox","subSubCategory":"Tillbehör","__v":0},{"_id":{"$oid":"5f30f4fb46107e12fd93a18e"},"ean":"5055856425908","productName":"Doom Eternal Deluxe Edition","lowestPrice":999,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Xbox","subSubCategory":"Spel","__v":0},{"_id":{"$oid":"5f30f4fb46107e12fd93a190"},"productName":"The Division 2 - The Phoenix Collectors Edition","lowestPrice":995,"mainCategory":"Spel & Gaming","group":"Teknik","subCategory":"Xbox","subSubCategory":"Spel","__v":0},{"_id":{"$oid":"5f30f4c346107e12fd933f09"},"ean":"6925281968471","productName":"JBL Tune 750BTNC Trådlösa Over-ear ANC-hörlurar - Svart","lowestPrice":1290,"mainCategory":"Ljud & Bild","group":"Teknik","subCategory":"Hörlurar","subSubCategory":"","__v":0},{"_id":{"$oid":"5f30f4c346107e12fd933f0b"},"ean":"4548736107274","productName":"Sony WF-XB700 Trådlösa in-ear Hörlurar - Svart","lowestPrice":1290,"mainCategory":"Ljud & Bild","group":"Teknik","subCategory":"Hörlurar","subSubCategory":"","__v":0},{"_id":{"$oid":"5f30f4c346107e12fd933f0d"},"ean":"5707055044786","productName":"Jabra Elite 65t Active Wireless in-ear hörlurar - Copper Blue","lowestPrice":1190,"mainCategory":"Ljud & Bild","group":"Teknik","subCategory":"Hörlurar","subSubCategory":"","__v":0},{"_id":{"$oid":"5f30f4da46107e12fd936ca1"},"ean":"0190199282544","productName":"Apple Watch Series 5 GPS + Cellular, 40mm Space Grey Aluminium Case with Black Sport Band","lowestPrice":6190,"mainCategory":"Mobil","group":"Teknik","subCategory":"Smartklocka","subSubCategory":"","__v":0},{"_id":{"$oid":"5f30f4da46107e12fd936c9d"},"ean":"0753759232887","productName":"Garmin Fenix 6S 42mm - Silver case with Black Band","lowestPrice":6390,"mainCategory":"Mobil","group":"Teknik","subCategory":"Smartklocka","subSubCategory":"","__v":0}]

Query

db.collection.aggregate([{$match:{group:"Teknik"}},{$group:{_id:{group:"$group",mainCategory:"$mainCategory",subCategory:"$subCategory"},subSubCategory:{$push:{name:"$subSubCategory"}}}},{$addFields:{subSubCategory:{$setUnion:["$subSubCategory",[]]}}},{$group:{_id:{group:"$_id.group",mainCategory:"$_id.mainCategory"},subCategory:{$push:{name:"$_id.subCategory",subSubCategory:"$subSubCategory"}}}},{$group:{_id:"$_id",mainCategory:{$push:{name:"$_id.mainCategory",subCategory:"$subCategory"}}}},{$project:{_id:0,group:"$_id.group",mainCategory:1}}])

Result