三级分销会员一次查询出来的SQL语句


        SELECT
	p.id AS partyId,
	p.parent_id AS parentId,
	pul.username AS userName,
	p.city,
	p.birth_date AS birthDate,
	p.phone AS telePhoneNo
FROM
	party p
LEFT JOIN party_user_login pul ON pul.party_id = p.id
WHERE 1=1 AND p.parent_id = 57
union all
SELECT
	p.id AS partyId,
	p.parent_id AS parentId,
	pul.username AS userName,
	p.city,
	p.birth_date AS birthDate,
	p.phone AS telePhoneNo
FROM
	party p
LEFT JOIN party_user_login pul ON pul.party_id = p.id
WHERE 1=1 AND p.parent_id in (
SELECT partyId FROM (SELECT
	p.id AS partyId,
	p.parent_id AS parentId,
	pul.username AS userName,
	p.city,
	p.birth_date AS birthDate,
	p.phone AS telePhoneNo
FROM
	party p
LEFT JOIN party_user_login pul ON pul.party_id = p.id
WHERE
	1 = 1
AND p.parent_id = 57 ) AS secondLevelIds)
union all
SELECT
	p.id AS partyId,
	p.parent_id AS parentId,
	pul.username AS userName,
	p.city,
	p.birth_date AS birthDate,
	p.phone AS telePhoneNo
FROM
	party p
LEFT JOIN party_user_login pul ON pul.party_id = p.id
WHERE 1=1 AND p.parent_id in (
select partyId FROM (SELECT
	p.id AS partyId,
	p.parent_id AS parentId,
	pul.username AS userName,
	p.city,
	p.birth_date AS birthDate,
	p.phone AS telePhoneNo
FROM
	party p
LEFT JOIN party_user_login pul ON pul.party_id = p.id
WHERE 1=1 AND p.parent_id in (
SELECT partyId FROM (SELECT
	p.id AS partyId,
	p.parent_id AS parentId,
	pul.username AS userName,
	p.city,
	p.birth_date AS birthDate,
	p.phone AS telePhoneNo
FROM
	party p
LEFT JOIN party_user_login pul ON pul.party_id = p.id
WHERE
	1 = 1
AND p.parent_id = 57 ) AS secondLevelIds) )AS thirdLevelIds)

相关阅读:
DAO模式多表联查
使用ADO.NET访问数据库
连接查询和分组查询
模糊查询和聚合函数
poj 1220 NUMBER BASE CONVERSION
poj 1964 City Game
Odd number problem
POJ 2983 M × N Puzzle
L O V E
【Mybatis】【3】处理大于号小于号及其他特殊字符

原文地址：https://www.cnblogs.com/jpfss/p/8709876.html