56,912
社区成员




select m2.id,m2.name,m2.p_id,
concat(
if(m0.order is null,'',concat(m0.order,'-')),
if(m1.order is null,'',concat(m1.order,'-')),
m2.order
) as neworder
from menu m2 left join menu m1 on m2.p_id=m1.id
left join menu m0 on m1.p_id=m0.id
SELECT m2.id, m2.name, m2.p_id, CONCAT( IF( m0.order IS NULL , '', CONCAT( LPAD( m0.order, 3, 0 ) , '-' ) ) , IF( m1.order IS NULL , '', CONCAT( LPAD( m1.order, 3, 0 ) , '-' ) ) , LPAD( m2.order, 3, 0 ) ) AS neworder
FROM menu m2
LEFT JOIN menu m1 ON m2.p_id = m1.id
LEFT JOIN menu m0 ON m1.p_id = m0.id
ORDER BY `neworder` ASC