有文章说明或者证明MYSQL 嵌套子查询不足之处吗?

请问一下MySQL 5.7和MySQL 8.0 多级嵌套子查询能力怎么样

select xxx,sum(yyyy) from merchant_info sm LEFT JOIN merchant_report mr on mr.merchant_id=sm.merchant_idLEFT JOIN (          SELECT ss.salesman_id,ss.salesman_name,sa.salesman_name AS 'salesSupervisorName' 	FROM(              SELECT sm.salesman_id,sm.salesman_name,sa.sales_id AS 'salesSupervisorNo' 			  FROM(                  SELECT sm.salesman_id,sm.salesman_name,op.parent_id				  FROM sales_man sm                  LEFT JOIN sales_parent op ON sm.salesman_id=op.sales_id              )sm LEFT JOIN sales_operator sa ON sm.parent_id=sa.id          )ss LEFT JOIN sales_man sa ON ss.`salesSupervisorNo`=sa.salesman_id      ) ss ON sm.salesman_id=ss.salesman_id      where 1=1                      and mr.sales_ID IN           (                '1'           ,               '2'           ,               '3'           ) 

其中 嵌套进去的子查询,目标是形成 销售姓名,销售领导ID,销售员ID,销售员姓名

当心嵌套子查询的执行计划是否稳定, 因为这个嵌套子查询要应用到多个大表的查询里面去.

虽然MYSQL 规范 JION不要超过3张表, 使用阿里云的RDS FOR MYSQL 感觉没有什么特别慢的地方