Export data from a MariaDB database to an XML file with a MultiNode structure

I need to export data from a MariaDB database to an XML file with a MultiNode structure, where one parent node contains multiple child nodes. While MySQL has built-in functionality to export data to XML, MariaDB currently lacks this feature.

I have a setup where data from two tables (e.g., "parents" and "children") needs to be exported in an XML format, with each parent node containing multiple child nodes. Currently, I can only achieve this through complex workarounds using CONCAT and GROUP_CONCAT in SQL queries or by relying on external programming languages like PHP or Python to handle the XML generation.

It would be helpful if MariaDB could offer native support for exporting data to XML in such structures, similar to MySQL’s XML export feature, or provide functions to simplify the process.