asp如何实现从数据库读取id值后，在变成这样的排列。。。

rs1.open"select * from jiaoyuanclass where jiaoyuanid="&session("id") &"",conn,1,1 '计算辅导工资     
do while not rs1.eof
if rs1("yifu")=0 then      
     ' response.write rs1("riqi") &"<BR>"
      chazhi=datediff("d",date1,rs1("riqi"))
      chazui=datediff("d",date2,rs1("riqi"))
        if chazhi>=0  and chazui<=0 then
           gongzi = gongzi + rs1("fudaogongzi")
           kcwei=gongzi '未审课程的工资
           if xyid="" then     '在该开始日期和结束日期内的学员的id  以便知道在该时间段内辅导的学员与老师学员表xuejiao的比较
             xyid=""&rs1("xueyuanid")&""
            else
              xyid=xyid+"|" + ""&rs1("xueyuanid")&""
            end if  '结束
        end if   
end if
rs1.movenext
loop
rs1.close
 response.write xyid
 response.end