如何对指定用户score的值进行查表排

我想查询用户组为5，并且在dr_member_data 表中的qxmc字段值是zx和xbj字段值是1的用户的score总数进行排行，需要怎么写呢？下面这样写好像不行

{member num=30 order=score groupid=5 sql="SELECT m.* FROM dr_member m LEFT JOIN dr_member_data d ON m.id=d.id WHERE d.qxmc='zx' AND d.xbj='1'"}

<div class="aui-flex b-line">

    <div class="aui-ranking-text one">

        <div class="number_top_circle"><strong>{$key+1}</strong></div>

    </div>

    <div class="aui-ranking-name aui-flex-box">

        <h2><strong>{$t.name}</strong></h2>

    </div>

    <div class="aui-ranking-num"><strong>{$t.score}</strong>&nbsp;&nbsp;</div>

    <div class="aui-ranking-icon">

        <img src="/images/小红花.png" alt="" style="width:26px;">

    </div>

    </div>

    {/member}