subselect mysql_mysql-将值传递给Subselect

SELECT

u.*,

GROUP_CONCAT(DISTINCT f.shot_id SEPARATOR ",") AS ownFavorites,

GROUP_CONCAT(DISTINCT st.shot_id SEPARATOR ",") AS ownStars,

GROUP_CONCAT(DISTINCT s.id SEPARATOR ",") AS ownShots,

( SELECT AVG(p.count)

FROM points p

LEFT JOIN shots s ON s.user_id = **U.ID** AND p.shot_id = s.id

WHERE date >= DATE_SUB(CURDATE(),INTERVAL 2 DAY)

) AS attention,

( SELECT SUM(p.count)

FROM points p

LEFT JOIN shots s ON s.user_id = **U.ID** AND s.id = p.shot_id

) AS popularity

FROM users u

LEFT OUTER JOIN shots s ON s.user_id = u.id

LEFT OUTER JOIN favorites f ON f.user_id = u.id

LEFT OUTER JOIN stars st ON st.user_id = u.id

WHERE u.username = ?;

我得到了两个使用参数u.id的子选择(在查询中标记).如果我做这样的SQL,它将生成类似的东西：

#1054 - Unknown column 'u.id' in 'on clause'

意思是,在子选择中未定义u.id id.但是在MainSelect中,我从存在u.id的users表中进行选择.

对我的问题：有没有一种方法可以将选定的u.id值传递给具有普通sql的Subselects？