[{"sections":[{"_id":{"$oid":"64cbeb62b669cd29a5719a8f"},"categories":[{"measureValues":["64cbeb62b669cd29a5719a95","64cbeb62b669cd29a5719a99"]}]}],"measures":[{"_id":{"$oid":"64cbeb62b669cd29a5719a93"},"name":{"64cbeb62b669cd29a5719a92":{"nodeType":"nodeName","value":"measure-1"}},"measureValues":[{"_id":{"$oid":"64cbeb62b669cd29a5719a95"},"measureValues":{"nodeName":{"64cbeb62b669cd29a5719a94":{"nodeType":"nodeName","value":"measureValue","_class":"com.myapp.cqrsdemo.model.DataObj"}},"comment":{"64cbeb62b669cd29a5719a97":{"nodeType":"comment","value":"this is a comment","_class":"com.myapp.cqrsdemo.model.DataObj"}}},"categoriesIds":["64cbeb62b669cd29a5719a91"],"measureName":"measure-1"},{"_id":{"$oid":"64cbeb62b669cd29a5719a99"},"measureValues":{"nodeName":{"64cbeb62b669cd29a5719a98":{"nodeType":"nodeName","value":"measureValue","_class":"com.myapp.cqrsdemo.model.DataObj"}},"date":{"64cbeb62b669cd29a5719a9b":{"nodeType":"date","value":"2023-02-02","_class":"com.myapp.cqrsdemo.model.DataObj"}}},"categoriesIds":["64cbeb62b669cd29a5719a91"],"measureName":"measure-1"}]}],"_class":"com.myapp.cqrsdemo.model.ProjectGroup"}]

db.collection.aggregate([{$set:{sections:{$let:{vars:{measureValuesArr:{$reduce:{input:"$measures",initialValue:[],in:{$concatArrays:["$$value","$$this.measureValues"]}}},},in:{$map:{input:"$sections",as:"s",in:{$mergeObjects:["$$s",{categories:{$map:{input:"$$s.categories",as:"c",in:{$mergeObjects:["$$c",{measureValues:{$map:{input:"$$c.measureValues",as:"m",in:{$arrayElemAt:["$$measureValuesArr",{$indexOfArray:["$$measureValuesArr._id",{$toObjectId:"$$m"}]}]}}}}]}}}}]}}}}}}}])