thinkPHP6多表查询

//多表查询
public function index()
{
    $this->title = '用户提现管理';
    $this->transfer = UserTransferService::instance()->amount(0);
    // 创建查询对象
    $query = DataUserTransfer::mQuery()->order('id desc');
    // 用户条件搜索
    $db = DataUser::mQuery()->like('phone,username|nickname#nickname')->db();
    if ($db->getOptions('where')) $query->whereRaw("uuid in {$db->field('id')->buildSql()}");
    // 数据列表处理
    $query->equal('type,status')->dateBetween('create_at')->page();
}

column()使用

$users = SystemUser::mk()->column('nickname,username', 'id');
$this->success('获取成功', $users);
{
  "code": 1,
  "info": "获取成功",
  "data": {
    "10000": {
      "nickname": "系统管理员",
      "username": "admin",
      "id": 10000
    },
    "10001": {
      "nickname": "aass",
      "username": "assa",
      "id": 10001
    }
  }
}

$users = SystemUser::mk()->column('nickname,username');
$this->success('获取成功', $users);

{
  "code": 1,
  "info": "获取成功",
  "data": [
    {
      "nickname": "系统管理员",
      "username": "admin"
    },
    {
      "nickname": "aass",
      "username": "assa"
    }
  ]
}


$users = SystemUser::mk()->column('nickname,username');
$user = array_unique(array_column($users, 'username'));
$this->success('获取成功', $user);

{
  "code": 1,
  "info": "获取成功",
  "data": [
    "admin",
    "assa"
  ]
}

$a = ['语文','属性'];
$this->success('获取成功', arr2str($a));
"data": ",语文,属性,"

$a = '1,2,3,4';
$this->success('获取成功', str2arr($a));
{
  "code": 1,
  "info": "获取成功",
  "data": [
    "1",
    "2",
    "3",
    "4"
  ]
}