mysql 根据一张表中的两个字段拿另外一张表中的同一个字段的查询

select
   t1.*,
   t2. name as driverName,
   t3. name as managerName
FROM
   comprehen_shuttlebuses AS t1
INNER JOIN sys_user AS t2 ON t1.driver_id = t2.id
INNER JOIN sys_user AS t3 ON t1.manager_id = t3.id
其中comprehen_shuttlebuses表中的driverName和managerName对应的是sys_user表中的name.