树目录两种实现方式

 表结构sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50527
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50527
File Encoding         : 65001

Date: 2020-11-03 18:11:12
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tbl
-- ----------------------------
DROP TABLE IF EXISTS `tbl`;
CREATE TABLE `tbl` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl
-- ----------------------------
INSERT INTO `tbl` VALUES ('1', '陕西省', '0');
INSERT INTO `tbl` VALUES ('11', '西安市', '1');
INSERT INTO `tbl` VALUES ('12', '宝鸡市', '1'