Real symmetric matrices can be diagonalized by orthogonal matrices , i.e. $$ OSO^{T} = D $$ where $O \in \text{O}(N)$ is an orthogonal matrix, $S$ is real and symmetric, i.e. $S^T = S$ and $D$ is diagonal. Similarly hermitian matrices can be diagonalized by unitary matrices. Now, my question is whether there a is a general relation that elements of a Lie algebra can be diagonalized via elements of their Lie group. For example does a similar statement hold for the symplectic group $\text{Sp}(N)$?
I am aware that the Lie algebra of the orthogonal matrices $O(N)$ is actually $\mathfrak{o}(N)$, the skew-symmetric matrices. Similarly, the corresponding Lie algebra of unitary matrices are the skew-hermitian matrices. Still is the fact that symmetric or hermitian matrices can be diagonalized as above only true for these two groups or is there a more general statement for maybe semi-simple Lie algebras.
Thank you very much for your answers in advance. I look forward to learning something new. Forgive me as a physicist if my answer was not posed completely mathematically rigorous.