Database
[{"_id":{"$oid":"60e519db4e0f140328adc7c7"},"trans":{"en":{"name":"Graphics And Design","description":"Graphics And Design"},"fr":{"name":"Graphics And Design","description":"Graphics And Design"}},"counts":{"$numberInt":"0"},"is_visible":true,"slug":"graphics-and-design","image":"","created_at":{"$numberDouble":"1625627099104.0"},"subcategories":[{"trans":{"en":{"name":"LOGO DESIGN","description":"LOGO DESIGN"},"fr":{"name":"LOGO DESIGN","description":"LOGO DESIGN"}},"counts":{"$numberInt":"0"},"slug":"logo-design","is_visible":true,"image":"","_id":{"$oid":"60e51a116678530e84ee2e61"},"created_at":{"$numberDouble":"1625627153535.0"},"service_type":[{"trans":{"en":{"name":"3D logo","description":"3D logo design"},"fr":{"name":"3D logo","description":"3D logo design"}},"counts":{"$numberInt":"0"},"is_visible":true,"_id":{"$oid":"60e51a116678530e84ee2e60"},"image":"","slug":"null","created_at":{"$numberDouble":"1625627153535.0"},"gig_meta_data":[]}]},{"trans":{"en":{"name":"BRAND STYLE GUIDES","description":"BRAND STYLE GUIDES"},"fr":{"name":"BRAND STYLE GUIDES","description":"BRAND STYLE GUIDES"}},"counts":{"$numberInt":"0"},"slug":"brand-style-guides","is_visible":true,"image":"","_id":{"$oid":"60e51a116678530e84ee2e63"},"created_at":{"$numberDouble":"1625627153535.0"},"service_type":[{"trans":{"en":{"name":"Brand style 1","description":"Brand style 1"},"fr":{"name":"Brand style 1","description":"Brand style 1"}},"counts":{"$numberInt":"0"},"is_visible":true,"_id":{"$oid":"60e51a116678530e84ee2e62"},"image":"","slug":"null","created_at":{"$numberDouble":"1625627153535.0"},"gig_meta_data":[]},{"trans":{"en":{"name":"Brand style 2","description":"Brand style 2"},"fr":{"name":"Brand style 2","description":"Brand style 2"}},"counts":{"$numberInt":"0"},"is_visible":true,"_id":{"$oid":"60e51a116678530e84ee2e62"},"image":"","slug":"null","created_at":{"$numberDouble":"1625627153535.0"},"gig_meta_data":[]}]}],"updated_at":{"$date":{"$numberLong":"1625627153547"}}},{"_id":{"$oid":"60e519db4e0f140328adc7c8"},"trans":{"en":{"name":"Graphics And Design2","description":"Graphics And Design2"},"fr":{"name":"Graphics And Design2","description":"Graphics And Design2"}},"counts":{"$numberInt":"0"},"is_visible":true,"slug":"graphics-and-design2","image":"","created_at":{"$numberDouble":"1625627099104.0"},"subcategories":[{"trans":{"en":{"name":"LOGO DESIGN2","description":"LOGO DESIGN2"},"fr":{"name":"LOGO DESIGN2","description":"LOGO DESIGN2"}},"counts":{"$numberInt":"0"},"slug":"logo-design2","is_visible":true,"image":"","_id":{"$oid":"60e51a116678530e84ee2e61"},"created_at":{"$numberDouble":"1625627153535.0"},"service_type":[{"trans":{"en":{"name":"3D logo2","description":"3D logo design2"},"fr":{"name":"3D logo2","description":"3D logo design2"}},"counts":{"$numberInt":"0"},"is_visible":true,"_id":{"$oid":"60e51a116678530e84ee2e60"},"image":"","slug":"null","created_at":{"$numberDouble":"1625627153535.0"},"gig_meta_data":[]}]},{"trans":{"en":{"name":"BRAND STYLE GUIDES2","description":"BRAND STYLE GUIDES2"},"fr":{"name":"BRAND STYLE GUIDES2","description":"BRAND STYLE GUIDES2"}},"counts":{"$numberInt":"0"},"slug":"brand-style-guides2","is_visible":true,"image":"","_id":{"$oid":"60e51a116678530e84ee2e63"},"created_at":{"$numberDouble":"1625627153535.0"},"service_type":[{"trans":{"en":{"name":"Brand style 12","description":"Brand style 12"},"fr":{"name":"Brand style 12","description":"Brand style 12"}},"counts":{"$numberInt":"0"},"is_visible":true,"_id":{"$oid":"60e51a116678530e84ee2e62"},"image":"","slug":"null","created_at":{"$numberDouble":"1625627153535.0"},"gig_meta_data":[]},{"trans":{"en":{"name":"Brand style 22","description":"Brand style 22"},"fr":{"name":"Brand style 22","description":"Brand style 22"}},"counts":{"$numberInt":"0"},"is_visible":true,"_id":{"$oid":"60e51a116678530e84ee2e62"},"image":"","slug":"null","created_at":{"$numberDouble":"1625627153535.0"},"gig_meta_data":[]}]}],"updated_at":{"$date":{"$numberLong":"1625627153547"}}}]
Query
db.collection.aggregate([{$addFields:{trans:"$trans.en",subcategories:{$map:{input:"$subcategories",as:"s",in:{$mergeObjects:["$$s",{trans:"$$s.trans.en",service_type:{$map:{input:"$$s.service_type",in:{$mergeObjects:["$$this",{trans:"$$this.trans.en"}]}}}}]}}}}}])