select count(*)
from t21_eap_acc_base_info a left join t21_eap_acc_punish_info b on a.accbaseid = b.accbaseid where 1 = 1
group by a.accbaseid, a.usercode , a.username ,a.belongorglevel ,a.happenorgname ,a.happendeptname ,a.postlevel ,a.joblevel ,a.createtime
order by a.username
请问这条SQL咋样求出他的总的条数,用于分页。或者说有没有更好的方法