通过tree_path判断某人是上级的第几级

第几级上级：

select (length(tree_path)-length(replace(tree_path, ',',''))-find_in_set(1063, tree_path)+2) level

from t_user where find_in_set(1063, tree_path)  

查找某人的第2级下级列表

select * from t_user where find_in_set(1063, tree_path)   and (length(tree_path)-length(replace(tree_path, ',',''))-find_in_set(1063, tree_path)+2) =2