$Model->Table('think_user user')

->where('status>1')

->select();

$Model->table('think_blog blog,think_type type')
->where('blog.typeid=type.id')
->field('blog.id as id,blog.title,blog.content,type.typename as type')
->order('blog.id desc' )
->limit(5)
->select();

xxx表中有字段category_id=分类id和post_id=文章id

aaa表中的id关联xxx表的文章id

怎么查询xxx表指定分类_id下的所有文章

评论