mysql path匹配_mysql path妙用

INSERT INTO `lc_c_user_path`(`id`, `user_id`, `username`, `store_id`, `user_id_path`, `username_path`, `store_id_path`, `complete_path`) VALUES (1, 'us1', 'un1', 's1', 'us0', 'un0', 's0', 'us0');

INSERT INTO `lc_c_user_path`(`id`, `user_id`, `username`, `store_id`, `user_id_path`, `username_path`, `store_id_path`, `complete_path`) VALUES (2, 'us2', 'un2', 's2', 'us1/us0', 'un1/un0', 's1/s0', 'us1/us0');

INSERT INTO `lc_c_user_path`(`id`, `user_id`, `username`, `store_id`, `user_id_path`, `username_path`, `store_id_path`, `complete_path`) VALUES (3, 'us3', 'un3', 's3', 'us2/us1/us0', 'un2/un1/un0', 's2/s1/s0', 'us2/us1/us0');

INSERT INTO `lc_c_user_path`(`id`, `user_id`, `username`, `store_id`, `user_id_path`, `username_path`, `store_id_path`, `complete_path`) VALUES (4, 'us4', 'un4', NULL, 'us3/us2/us1/us0', 'un3/un2/un1/un0', 's3/s2/s1/s0', 'us3/us2/us1/us0');

INSERT INTO `lc_c_user_path`(`id`, `user_id`, `username`, `store_id`, `user_id_path`, `use