php递归实现无限分类原理-PHP源码

DROP TABLE IF EXISTS `navs`;
CREATE TABLE IF NOT EXISTS `navs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `pid` int(11) NOT NULL DEFAULT &＃39;0&＃39;,
  `path` char(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `navs` (`id`, `name`, `pid`) VALUES
(1, &＃39;舞文弄墨&＃39;, 0, &＃39;-1-&＃39;),
(2, &＃39;似水流年&＃39;, 2, &＃39;-2-&＃39;),
(3, &＃39;隔岸观火&＃39;, 2, &＃39;-2-3-&＃39;),
(4, &＃39;WEB开发&＃39;, 0, &＃39;-4-&＃39;),
(5, &＃39;PHP&＃39;, 4, &＃39;-4-5-&＃39;),
(6, &＃39;Javascript&＃39;, 4, &＃39;-4-6-&＃39;);
(7, &＃39;jquery&＃39;, 6, &＃39;-4-6-7-&＃39;);