1、例如管理员和角色表:
管理员表:
CREATE TABLE `admins` (
`adminid` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(90) NOT NULL COMMENT '姓名',
`role_id` tinyint(2) NOT NULL COMMENT '角色ID',
PRIMARY KEY (`adminid`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8
角色表:
CREATE TABLE `roles` (
`roleid` smallint(6) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
`name` varchar(100) NOT NULL COMMENT '角色名称'
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
2、管理员表模型:
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class AdminsModel extends Model {
/**
* @var string
*/
protected $connection = 'mysql';
/**
* @var string
*/
protected $table = 'admins';
/**
* @var string
*/
protected $primaryKey = 'adminid';
/**
* @return \Illuminate\Database\Eloquent\Relations\HasOne
*/
public function roleInfo() {
return $this->hasOne(RolesModel::class, 'roleid', 'role_id')->select(['roleid', 'name']);
}
}
3、根据角色名称筛选:
AdminsModel::where($condition)->with(['roleInfo'])->whereHas('roleInfo', function ($roleQuery) use ($roleName) {
if ($roleName) {
$roleQuery->where('name', '%' . $roleName . '%');
}
});