By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table member_records (user_id int)
insert into member_records values
(12359725),
(445),
(923587356),
(389475679)
Records: 4 Duplicates: 0 Warnings: 0
select user_id % 10000000 AS user_id
from member_records
| user_id |
|---|
| 2359725 |
| 445 |
| 3587356 |
| 9475679 |