-- 表的结构 `cate`
CREATE TABLE IF NOT EXISTS `cate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`pid` int(11) NOT NULL,
`path` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
INSERT INTO `cate` (`id`, `name`, `pid`, `path`) VALUES
(1, '新闻', 0, '0'),
(2, '中国新闻', 1, '0-1'),
(3, '美国新闻', 1, '0-1'),
(4, '北京新闻', 2, '0-1-2'),
(5, '华盛顿新闻', 3, '0-1-3'),
(6, '海淀新闻', 2, '0-1-2-4');
sql语句：
SELECT id, name, CONCAT( path, '-', id ) AS pathid
FROM think_cate
ORDER BY pathid
LIMIT 0 , 30