Use SELECT * only if you need all columns from table
select id,zh_cate_name as cate_name,zh_cate_name as front_cate_name,zh_cate_name,parent_id,cate_image,id_path,sort_order,left(id_path,3) as path,concat(id_path,id,',') as bpath from`juzi_category`where`juzi_category`.`deleted_at`isnullorderby`bpath`asc1.55ms11juzi_com