问一多级查询语句

数据表结构如下：WeekReportMissionId       ProjectTypeId        ConstructionId         WeekMissionCode    WeekMissionName
     1                          1                   1                      0                 任务1
     2                          1                   1                      0                 任务2
     3                          1                   1                      1                 任务11
     4                          1                   1                      1                 任务12
     5                          1                   1                      1                 任务13
     6                          1                   1                      2                 任务21以WeekMissionCode为记录父级ID（WeekReportMissionId）,我要根据ProjectTypeId,ConstructionId来决定得到什么样的任务数据。而且需要全部显示出来，比如ProjectTypeId和ConstructionId都等于1时，数据如下：WeekReportMissionId       ProjectTypeId        ConstructionId         WeekMissionCode    WeekMissionName
     1                          1                   1                      0                 任务1
     3                          1                   1                      1                 任务11
     4                          1                   1                      1                 任务12
     5                          1                   1                      1                 任务13
     2                          1                   1                      0                 任务2
     6                          1                   1                      2                 任务21谢谢。