Say:
select a.*,b.name,b.image,b.renzheng from shyl_xinxifabu a left join shyl_member b on a.memberid=b.id where a.navid=10 and a.isshow=1 and a.memberid= order by a.paixu desc,a.date desc,a.id desc limit 0,300