SELECT 
        p.*,
        pu.stav_uzivatele 
    FROM
        collab_projekty AS p,
        collab_projekty_uzivatele AS pu
    WHERE
        pu.id_uzivatele='41057'
        AND pu.id_projektu=p.id
    ORDER BY p.aktivni DESC,p.cas_vytvoreni DESC