表一:tbTaskSetting 查询的主表
表二:tbTaskGroup 附表,该表关联的id在主表的数量
select tg.TaskGroupID,TaskGroupName,COUNT(TaskGroupName) AS TaskCount from tbTaskSetting AS ts RIGHT JOIN tbTaskGroup AS tg on ts.TaskGroupID=tg.TaskGroupID GROUP BY TaskGroupName,tg.TaskGroupID