第一张表  字段: pers_role int

第二张表 字段 role_jurisdiction varchar

第三张表 

SELECT * FROM `router_table` AS ro WHERE  FIND_IN_SET(ro.router_id,(SELECT r.role_jurisdiction FROM `system_personnel` as s INNER JOIN `role` AS r ON s.pers_role=r.id WHERE s.id=1))