select a.classname,(select qqnum from tbl_CServiceQQ where classname=a.classname for xml path,root('root')) as numlist from tbl_CServiceQQ as a group by classname
select a.classname,(select qqnum from tbl_CServiceQQ where classname=a.classname for xml auto,root('root')) as numlist from tbl_CServiceQQ as a group by classname