Thanks for the reply. I agree such multi-level directory structure is meaningless, but it's hard to change the structure in production environment now. Fortunately we finally found an alternative solution, using the %H pattern with homedir_substring option.
Anyway, I think sssd should enhance the flexibility of home path modification. The substitution patterns currently provided is too simple to meet some complex path mapping requirement.