This is probably what you need

SELECTU.userid,

SUM( CASE WHEN U.userid = P.whoverified THEN 1 ELSE 0 END ) AS whoverified,

SUM( CASE WHEN U.userid = P.whochecked THEN 1 ELSE 0 END ) AS whochecked

FROMusers AS U

INNER JOIN rxproductivity AS P ON U.userid = P.whoverified OR U.userid = P.whochecked

GROUP BY U.userid