数据查询条件

设置默认排序

php

$table->model()->orderBy("money", "desc")；

//默认
$table->model()->orderBy('id', 'desc');

修改查询条件 (where)

php

$table->model()->where('id', '>', 100);

关联表

php

//with($model, $field = "*", $foreignKey = null, $localKey = null)
//$foreignKey为user_id,$localKey为id
$table->model()->with("user", "nickname,avatar");