SELECT CONCAT('\n<xml>', 
CONCAT('\n\t<products>',
GROUP_CONCAT('\n\t\t<products colum1="', colum1, '" colum2="', colum2, '" colum3="', colum3,'"/>' SEPARATOR ''),'\n\t</products>'),'\n</xml>') 
AS xmldoc FROM product;