phpcms 两个数据表关联写sql语句

{pc:get sql="SELECT * FROM v9_news AS a LEFT JOIN v9_news_data AS b ON a.id=b.id" num="5"}

 

 

{pc:content action="lists" catid="$catid" num="5" order="id DESC"}
{loop $data $v}
{php $db = pc_base::load_model('hits_model'); $_r = $db->get_one(array('hitsid'=>'c-'.$modelid.'-'.$v[id])); $views = $_r[views]; }
<li>< a href="{$v[url]}" target="_blank"{title_style($v[style])}>{$v[title]}</ a>点击:{$views}</li>
{/loop}
{/pc}