[php]Thinkphpテーブルクエリ

$list = M('list');  //      tp_

$sql = 'select * from tp_list as list, tp_article as article where list.sub_category = article.sub_category';

print_r($list->query($sql));

$listArticle = $list->join('__ARTICLE__ ON __LIST__.sub_category = __ARTICLE__.sub_category')->select();  // __ARTICLE__ = tp_article 

print_r($listArticle);

$listArticle = $list->table('tp_list as list, tp_article as article')->where('list.sub_category = article.sub_category')->select();

print_r($listArticle);