Get only active projects where request user is an active member if mode is
set to `member'.