double account email in cdbUsers Table

[miyaa]

Are you another way, so that there is no double account register in the cdbUsers table.

if I register with an email with the same password. then there will be a double account register.

example
email: email@example.com
password: Test123

and then

email: email@example.com
password: TEst123

then what happens in the cdbUsers table will occur 2 email accounts. I don't think this is ideal and it shouldn't be like this. There should be only 1 register account in the user table.

I tried to use the cdb_advancedQuery function but the users table cannot query. so you can't check if the same email can't double register.

Are there any other solutions to prevent double accounts?

Thanks