SELECT a.id,a.uid,a.piclist,a.content,a.agreenum,a.agreelist,a.addtime,b.sex,b.grade,b.nickname,b.love,b.photo_s,b.photo_f,b.birthday,b.pay,b.job,b.heigh,b.edu,b.areatitle,b.RZ,b.photo_ifshow FROM zeai_trend a,zeai_user b WHERE a.uid=b.id AND b.flag=1 AND a.flag=1 ORDER BY a.id DESC