phpcms v9 统计会员投稿总数

代码：
统计文章总数
{pc:get sql="SELECT count(*) as zs FROM phpcms_news "}
{loop $data $key $r}
{$r[zs]}
{/loop}
{/pc}

代码二：
统计某位会员发帖数量
{pc:get sql="SELECT count(*) as userconut FROM phpcms_news where username = '某会员名称' "}
{loop $data $key $r}
{$r[userconut]}
{/loop}
{/pc}

注：
select count(*)  查每个表有多少条记录