Some details on your pureFTPd/mysql setup would be helpfull.
TL;DR: PureFTPd doesn't support home directory template/skeleton
https://serverfault.com/questions/615487/create-home-directory-from-skeleton-upon-ftp-first-login
Also the userdir apache module rely on system auth to map username to home directory, if you only setup pureFTPd to query a mysql user database it won't work the way you expect.
You would need to make this mysql database a system authentication base by using components like libpam-mysql and libnss-mysql, given this setup in place you could then use pam-mkhomedir to spin-up a home directory template with this public_html folder.
I wouldn't recommend this however, a mod-rewrite based solution with a username.domain.tld mapping to /path/to/ftp/user/htdocs would be probably safer, and combined with Pro-FTPd ability to create the home directory based on a template this could work the way you want.
Of course there is also a third and probably simpler way: have your user-management interface create the home directory the way you want it.