单行显示三级分销记录（同表自join）

CREATE TABLE `d_user_invite` (
  `invite_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT ‘0‘,
  `phone` varchar(50) DEFAULT NULL,
  `invite_user_id` int(11) NOT NULL DEFAULT ‘0‘,
  `invite_user_phone` varchar(50) DEFAULT NULL,
  `add_date_time` int(11) NOT NULL,
  PRIMARY KEY (`invite_id`),
  KEY `ind_invite_userlD` (`user_id`) USING BTREE,
  KEY `ind_invite_inviteUserID` (`invite_user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SELECT
    `a`.`user_id` AS `uid`,
    `a`.`phone`,
    `a`.`invite_user_id` AS `suid`,
    `a`.`invite_user_phone` AS `sphone`,
    `b`.`invite_user_id` AS `ssuid`,
    `b`.`invite_user_phone` AS `ssphone`
FROM
    `d_user_invite` `a`
LEFT JOIN `d_user_invite` `b` ON `b`.`user_id` = `a`.`invite_user_id`
WHERE
    `a`.`user_id` <> `b`.`invite_user_id`