你可以这样做:

SELECT
    SUM(CASE WHEN val2=26 THEN 1 ELSE 0 END) AS following_count,
    SUM(CASE WHEN val3=26 THEN 1 ELSE 0 END) AS follower_count
FROM
    table1