And I also think there's also a bitcoin blockchain explorer that has that feature which can show the user other types of bitcoin address that is associated or shares the same private keys with the address they are at its transaction log at that time,
That's not possible at all and no blockchain explorer can do that.
For deriving the other types of an address, you need the private key. There is no way to know what addresses have been derived from the same private key unless you know the private key.