SELECT
                evidence_software.*,
                (SELECT COUNT(*) FROM evidence_software_users WHERE evidence_software_users.id_software = evidence_software.id) AS users,
                GROUP_CONCAT(zamestnanci_info.jmeno, ' ', zamestnanci_info.prijmeni ORDER BY zamestnanci_info.jmeno ASC SEPARATOR ', ') AS users_names
            FROM
                evidence_software
            RIGHT JOIN
                evidence_software_users ON evidence_software_users.id_software = evidence_software.id
            LEFT JOIN
                zamestnanci_info ON evidence_software_users.id_user = zamestnanci_info.id_user
            ORDER BY
                evidence_software.nazev