Generating a big XML file using PHP from data from multiple tables

[l2oot]

I have this XML file that is generated by PHP, but the amount of information it generates is small. Now I want to generate a one big XML file that will contain data from multiple tables which are associated with each other. But using the PHP to structure out the XML file is confusing because the SQL statement is getting very large. Is there any way to generate a big XMl File using PHP or any other tool?\[code\]$query = "SELECT institution_t.Name, institution_t.idColleges, campus_t.CampusName, campus_t.CampusAddress, campus_t.Lat, campus_t.Lng FROM institution_t JOIN campus_t ON (campus_t.idColleges = institution_t.idColleges)";\[/code\]This is just the SQL statement with two table I need to add 8 more tables which are associated with each other.