select 
    device_id,
    substring_index(blog_url,'/',-1) as user_name
from user_submit;