XML : Parse data from XML files(that contains "self-closing tag") and output to csv file

I have a big xml file, which is in format as below, and I want to transform it in csv otput as shown below. How can I do this, for example with, powershell, C#,....?

    <name type="p" id="1" country="Uk">        <prof>          <option1/>          <option2/>          <option3/>        </prof>    </name>     <name type="p" id="2">        <prof>          <option1/>          <option2/>        </prof>    </name>     <name type="p" id="3"  country="USA">        <prof>          <option2/>          <option3/>        </prof>    </name>    

And the csv output I need is: "id","country","prof" 1,Uk,'option1,option2,option3' 2,'option1,option2' 3,USA,'option2,option3'