21,886
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM tables AS b
LEFT JOIN (SELECT * FROM(
SELECT parent_id as gl_id,COUNT(parent_id) as count_pid FROM tables GROUP BY parent_id) as a) AS c ON b.id=c.gl_id ORDER BY c.count_pid DESC
不知道你说的是不是这个意思
gl_id就是parent_id的值,count_pid就是统计parent_id这个值得个数