water/server/inspect_agent_data.php

<?php

require __DIR__ . '/vendor/autoload.php';
\Dotenv\Dotenv::createUnsafeMutable(__DIR__)->load();
\support\App::loadAllConfig(['route']);
\Webman\ThinkOrm\ThinkOrm::start(null);

$users = \support\think\Db::table('sa_system_user')
    ->whereNull('delete_time')
    ->field('id,username,realname,phone,avatar,dept_id,status,remark,create_time')
    ->order('id')
    ->select()
    ->toArray();
$depts = \support\think\Db::table('sa_system_dept')
    ->whereNull('delete_time')
    ->field('id,parent_id,name,level,status')
    ->order('id')
    ->select()
    ->toArray();
$roles = \support\think\Db::table('sa_system_user_role')->alias('ur')
    ->leftJoin('sa_system_role r', 'r.id=ur.role_id')
    ->field('ur.user_id,r.id AS role_id,r.name,r.code,r.level,r.status')
    ->order('ur.user_id')
    ->select()
    ->toArray();
$devices = \support\think\Db::table('sa_device')
    ->whereNull('delete_time')
    ->field('manage_agent_id,belong_agent_id,COUNT(*) AS total')
    ->group('manage_agent_id,belong_agent_id')
    ->select()
    ->toArray();

echo json_encode(compact('users', 'depts', 'roles', 'devices'), JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT);