近五年纳统企业分布

	SELECT
		a.click_date name,
		ifnull(b.count, 0) AS value
	FROM
	(
		SELECT
			YEAR (now()) AS click_date
		UNION ALL
			SELECT
				YEAR (now()) - 1 AS click_date
			UNION ALL
				SELECT
					YEAR (now()) - 2 AS click_date
				UNION ALL
					SELECT
						YEAR (now()) - 3 AS click_date
					UNION ALL
						SELECT
							YEAR (now()) - 4 AS click_date
		) a
	    LEFT JOIN (
			SELECT
				id,
				ntyear,
				count(id) count
			FROM
				t_user
			WHERE
				role = '4'
			GROUP BY
				ntyear
	) b ON a.click_date = b.ntyear
	ORDER BY value  DESC