计划量、入库量、出库量的有关问题

计划量、入库量、出库量的问题
高手帮忙：
      Table  :M_Tree（项目结构表）
                    ProjectNo                      ProjectName                   ParentProjectNo
                         0                          平台                                          Null
                         1                           A项目                                          0
                         2                           A-1子项目                                  1
                         3                           A-2子项目                                  1
                         4                           B项目                                         0
                         5                           B-1子项目                                  4
                         6                           A-2-2子项目                               3 
                   M_PlanDetail（计划结构表）
                    No                    MaterialName                   PlannedQty                   PlanProjectNo      PlanUserName
                     1                       材料1                            10                             1               张三
                     2                       材料1                             5                             3               李四