SELECT a.*, b.* FROM `user` as a LEFT JOIN `user` as b ON a.pid = b.id AND a.salary > b.salary WHERE b.id > 0;
PHPsql
原文：https://www.cnblogs.com/yszr/p/10520489.html
