mysql下的数据排序(concat)->无限极列表(适用于产品分类标识)

select id,name,pid,path,CONCAT(path,'-',id) as bpath from test ORDER BY bpath