VBA在单个父节点下导入多个XML子节点

I'm trying to import data from a XML response into an excel sheet and I am having difficulty with repeated child nodes under a single parent node. I need to be able to import the CategoryID, CategoryName, and CategoryParentName lines for each category. I've been able to get the first two but cant figure out the CategoryParentName since its repeated. The XML is as follows.I'm trying to import data from a XML response i