SELECT Project, YearMonth,
IF(SUM(IF(WeekOrMonth='第一周',bz1,0))=1,'y','n'),
IF(SUM(IF(WeekOrMonth='第二周',bz1,0))=1,'y','n'),
IF(SUM(IF(WeekOrMonth='第三周',bz1,0))=1,'y','n'),
IF(SUM(IF(WeekOrMonth='第四周',bz1,0))=1,'y','n'),
IF(SUM(IF(WeekOrMonth='月报',bz1,0))=1,'y','n')
FROM (
SELECT Project,YearMonth,WeekOrMonth,1 AS bz1 FROM ttl2
UNION ALL
SELECT Project,'201306' AS rq,bz,0 AS bz1 FROM (SELECT DISTINCT a.`Project` FROM ttl2 a) a2,(
SELECT '第一周' AS bz
UNION
SELECT '第二周'
UNION
SELECT '第三周'
UNION
SELECT '第四周'
UNION
SELECT '月报'
) a1) a2
GROUP BY Project, YearMonth