select * from (
SELECT
	u.utm_source
	,count(DISTINCT u.mobile) as new_user -- 登记用户
	FROM 表名 u
	WHERE u.created_time BETWEEN '2019-03-01 00:00:00' AND '2019-03-01 23:59:59'  and u.utm_source in ('param1','param2')
	GROUP BY u.utm_source
	ORDER BY new_user DESC
	) t
	LEFT JOIN
(
	SELECT abbr as utm_source, `name`, type
	FROM
	表名
	WHERE abbr != ''
) qudao USING(utm_source) ;#limit $page,$page_count

　　其中的USING用法是：qudao.utm_source = u.utm_source，相当于：join 表名 as a on a.utm_source = u.utm_source

优质内容筛选与推荐>>
1、XML校验之sun.tools.internal.xjc.Driver
2、php的call_user_func_array()使用场景
3、用Beyond Compare如何管理你的会话
4、内容社交产品中的关键数据——获得良好反馈的用户比例
5、弹出提示窗口