SELECT cds.yearmonth yearmonth ,d.description pName, cds.pjt_id pid, sum(cds.people_num) peopleNum from t_bus_projpost_distribution_statistics cds LEFT JOIN t_s_depart d ON cds.pjt_id = d.ID where 1=1 <#if ( distributionEntity.yearMonthList )?? && distributionEntity.yearMonthList ?size gt 0> and cds.yearmonth in( <#list distributionEntity.yearMonthList as item> '${item}' <#if item_has_next>, ) GROUP BY cds.pjt_id