select t1.*, count(distinct name) from table t1
left join table2 t2 on t2.t1_id = t1.id
group by name
order by t2.order_colum
limit 0,1000
Nemo
管理员
路漫漫其修远兮，吾将上下而求索。
select t1.*, count(distinct name) from table t1
left join table2 t2 on t2.t1_id = t1.id
group by name
order by t2.order_colum
limit 0,1000
编程综合 
mysql