MySQL计算所有项目，聚合少于其他项目

I need to fetch data from many mysql 5.6 tables to create a pie chart. As you know, the pie chart is useful if it represents meaningful data. However when you have many non meaningful data points, say less than .. or non important values, the pie chart becomes unclear. I need to count the occurrence of each category and aggregate the not significant counts, less than X, as OTHERS.I need to fetch data from many mysql 5.6 tables