select top 1 userid,username,score,hits,userface,Homepagel,score,lastlogintime,channelid from ks_user u inner join ks_iteminfo i on u.username=i.inputer where i.infoid={$CurrInfoID} and i.channelid={$CurrChannelID}

空间地址在循环时用{$GetInstallDir}space/?{$Field(userid,Num,0,2)}/

需要其他字段可以再加~