MySQL相当于SQL Server FOR XML PATH

I am recently working this system with sql server, now i would like to swith with mysql for some reason. Ive got stuck in converting this line of codes to fit with mysql.. can someone give me a hand with this. here's the code:

 $sql = "
select t1.request_id,t1.user_id,t1.user_name,t1.dept_desc,t1.DivisionCode,t1.status,t1.remarks,
  STUFF((
    SELECT ',* '+convert(varchar(50),asd.technical_id)+'***'+convert(varchar(50),asd.category_id)+'***'+ asd.technical_desc
    FROM requesttechnical_tbl t2,technical_tbl asd
    WHERE t2.request_id = t1.request_id and asd.technical_id=t2.technical_id order by asd.category_id desc
    FOR XML PATH ('')),1,2,'') AS technical_desc,