自己搞定，语句如下

select KS_Article.ID,KS_Article.Title,KS_Article.Adddate,KS_Photo.ID,KS_Photo.Title,KS_Photo.PhotoUrl,KS_Photo.Adddate,KS_SpecialR.ID,KS_SpecialR.InfoID,KS_SpecialR.SpecialID from ( KS_SpecialR inner join KS_Article on KS_SpecialR.InfoID=KS_Article.ID ) INNER JOIN KS_Photo ON KS_SpecialR.InfoID=KS_Photo.ID where KS_SpecialR.SpecialID={$CurrSpecialID} order by KS_SpecialR.ID