---

SELECT 
    u.familiya AS 'Фамилия',
    u.imya AS 'Имя',
    p.nomer AS 'Номер прав',
    p.data_okonchaniya AS 'Дата окончания прав'
FROM users u
JOIN prava p ON u.id_user = p.id_user
WHERE p.data_okonchaniya < CURDATE()
ORDER BY u.familiya ASC;