如何在Laravel中进行多个子查询

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    protected $table = 'users';
}

<?php

namespace App\Http\Controllers;

use App\User;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class UserController extends Controller
{
    public function index()
    {
        // 使用Eloquent ORM进行子查询
        $users = User::whereIn('id', function ($query) {
            $query->select('user_id')
                ->from('posts')
                ->where('is_published', true);
        })->get();

        // 使用查询构建器进行子查询
        $subQuery = DB::table('comments')
            ->select('post_id')
            ->groupBy('post_id')
            ->havingRaw('COUNT(*) > 10');

        $posts = DB::table('posts')
            ->whereIn('id', $subQuery)
            ->get();

        // 返回查询结果
        return view('users.index', compact('users', 'posts'));
    }
}