查询下下级加下级数据

查询指定账号的下级账号的订单和下下级账号的订单

SELECT
	 SUM(oi.recharge_number) as rechareg,SUM(oi.actual_number) as actual
FROM
	order_info oi LEFT JOIN sys_user su ON oi.user_id = su.id  left JOIN sys_user ss ON ss.id = su.parent_id or oi.user_id = ss.id  WHERE ss.parent_id = "829500"  AND oi.state LIKE CONCAT('%', '已付款', '%')