一、关联模型(参数详解)
'mapping_type'=>self::HAS_ONE,
'class_name'=>'Card',//可不写
'mapping_name'=>'card',// 展示时Card改为card
'foreign_key'=>'uid', //外键
'mapping_fields'=>'code',//单独获取该键值
'as_fields'=>'code:mycode',//单独作为一个参数加入到主表中展示,":"后为变量名冲突时做修改
'condition'=>'id=1',//条件
二、多表查询+模糊查询示例
$data=$comment->join('user_table ON user_table.user_id=comment.user_id')->join('theme ON theme.theme_id=comment.theme_id')->field('comment.id,user_table.user_id,user_table.user_name,theme.theme_name,comment.content,comment.create_time')->limit($page,8)->where('user_table.user_name like "%'.$searchkey.'%" or theme.theme_name like "%'.$searchkey.'%"')->select();