mysql8递归查询
create table t_test( id varchar(64) not null primary key, name varchar(64), pid varchar(64));INSERT INTO `callcenter`.`t_test`(`id`, `name`, `pid`) VALUES ('1', '张三', '0');INSERT INTO `callcenter`.`t_test`(`id`, `name`, `pid`) VALUES ('2', '张儿子', '1'