Say:
select a.*,b.name,b.image,b.renzheng from shyl_tupianzhanshi a left join shyl_member b on a.memberid=b.id where a.navid=1 and a.zuixin=1 and a.yxq>'2025-04-19 02:33:10' and (a.paystatus=1 or a.first=1) and a.memberid= order by a.paixu desc,a.date desc,a.id desc limit 0,300