如何将我的列合并为一个以在MySQL中创建URI？

I have four columns that I would like to combine into one URL: region_slug, category_slug, listing_slug, and listing_id. Previously, I have been using PHP to do this but this can be repetitive, especially if I ever decide to change the format of the URI. I would like a single alias to return a URI like '{region_slug}/{category_slug}/{listing_slug}/{listing_id}. So I would basically like to do something like I have four columns that I would like to combin