Provider::getPrimaryUsersQuery

public function getPrimaryUsersQuery(array $projectIds): Query
{
	$query = UserToGroupTable::query();
	$query
		->setSelect([
			'GROUP_ID',
			'USER_ID',
			'ROLE',
			'INITIATED_BY_TYPE',
			'AUTO_MEMBER',
			'NAME' => 'USER.NAME',
			'LAST_NAME' => 'USER.LAST_NAME',
			'SECOND_NAME' => 'USER.SECOND_NAME',
			'LOGIN' => 'USER.LOGIN',
			'PERSONAL_PHOTO' => 'USER.PERSONAL_PHOTO',
		])
		->where('GROUP.ACTIVE', 'Y')
		->where('USER.ACTIVE', 'Y')
		->whereIn('GROUP_ID', $projectIds)
	;

	return $query;
}