MySQL 子查询以字段作为子查询条件

SELECT *, tid AS aaa, ( SELECT uid FROM record WHERE tid = aaa AND win = 1 ORDER BY `value` DESC LIMIT 1 ) AS other_uid FROM `record`

查出同一局玩战绩 是谁赢了， 用tid当子查询条件 去筛选（小问题未知，不能直接用字段tid去当条件，要起别名aaa才能去当条件）