codeigniter 4 select in select查询

use CodeIgniter\Database\ConnectionInterface;
use CodeIgniter\Database\Query;

class YourController extends BaseController
{
    protected $db;

    public function __construct(ConnectionInterface $db)
    {
        $this->db = $db;
    }

    public function yourMethod()
    {
        $builder = $this->db->table('your_table');
        // 构建查询
    }
}

$builder->select('*')
        ->from('your_table')
        ->whereIn('your_field', function (Query $builder) {
            return $builder->select('another_field')
                           ->from('another_table')
                           ->where('another_condition', 'value')
                           ->getCompiledSelect();
        });

$query = $builder->get();
$result = $query->getResult();