多字段关联同一张表

select 
*,
(select UserName from T_Users where Id=AssayUserId) as AssayUserName,
(select UserName from T_Users where Id=AnalyzeUserId) as AnalyzeUserName
from T_task