Kimai_Database_Mysql::membership_roles PHP Method

    public function membership_roles()
    {
        $p = $this->kga['server_prefix'];
        $query = "SELECT a.*, COUNT(DISTINCT b.userID) as count_users FROM `{$p}membershipRoles` a LEFT JOIN `{$p}groups_users` b USING(membershipRoleID) GROUP BY a.membershipRoleID";
        $result = $this->conn->Query($query);
        if ($result == false) {
            $this->logLastError('membership_roles');
            return false;
        }
        $rows = $this->conn->RecordsArray(MYSQLI_ASSOC);
        return $rows;
    }