数据库实现语句
select c.id,c.parentid,c.title,d.title as '上级名称'
from (select id,parentid,title from nav a where exists(select * from nav b where b.id=a.parentid)) c,nav d
where d.id=c.parentid
数据库实现语句
select c.id,c.parentid,c.title,d.title as '上级名称'
from (select id,parentid,title from nav a where exists(select * from nav b where b.id=a.parentid)) c,nav d
where d.id=c.parentid