group select - CodeIgniter 4 builder

group.php

<?php
    $builder->select('id, email, name, phone, created_at, status');
		$groupSelect = '(SELECT GROUP_CONCAT(ag.name) FROM auth_groups_users gu LEFT JOIN auth_groups ag ON ag.id=gu.group_id WHERE gu.user_id=users.id) AS groups';
		$builder->select($groupSelect);
		$builder->where('deleted_at', NULL);
		$builder->limit($limit, $offset);

		// get select, for calc filtered
		$compiledSelect = $builder->getCompiledSelect(FALSE);
		$compiledSelect = str_replace($groupSelect, '', $compiledSelect);

		$query = $builder->get();

		$data['data'] = $query->getResultArray();