sql統計(jì)語句

{sql "select count(id) as sl,username from fn_content_1 where status=1 group by userid"}

    <p>姓名：{$t['username']} 數量：{$t['sl']}</p>

{/sql}