YII2 query的数据库操作

xiaoxiao2021-02-28  66

$query = new Query(); $query->select('title,content,task.enable,task.id'); $query->from('task'); $query->leftJoin('task_user_rel', 'task.id= task_user_rel.task_id'); $query->leftJoin('user', 'task_user_rel.user_id = user.id'); $query->leftJoin('org_user_rel', 'user.id = org_user_rel.user_id'); $query->leftJoin('org', 'org_user_rel.org_id =org.id'); $query->where([ 'org.id' => $orgModel->id ]); $data = $query->all(); $data = $query->one();

 

转载请注明原文地址: https://www.6miu.com/read-79149.html

最新回复(0)