MySQL数据库 select中的子查询不能使用之前的别名

Question

SELECT
    a.resourceID AS resourceID,
    b.menuName AS selfName,
    a.selfType AS selfType,
    b.menuID AS tempID,
    (
        SELECT COUNT(*) AS number
        FROM sys_role_resource
        WHERE selfType = 'SYS_MENU' AND parentType = 'SYS_MENU' 
              AND parentID = tempID
    ) AS menuNum,
    (
        SELECT COUNT(*) AS number
        FROM sys_role_resource
        WHERE selfType = 'SYS_ELEMENTS' AND parentType = 'SYS_MENU' 
              AND parentID = tempID
    ) AS elementNum
FROM
    sys_role_resource a INNER JOIN sys_role_menu b ON a.selfID = b.menuID
    AND a.selfType = 'SYS_MENU'
    AND a.parentType = 'SYS_APP'
    AND b.isDelete = 1
WHERE
    a.parentID = 7

SQL语句如上
现在有两个MySQL数据库（5.6, 5.7），表结构和数据相同，但是为什么能在5.6的数据库中执行，但是在5.7的数据库里就执行不了。
是因为数据库版本的问题吗？还是因为5.7的数据库是我刚搭建的，没进行什么相关配置啊？
求大神指导啊 T_T

Answer 1

是怎么解决的？？？