SQL select all terms from a taxonomy

Select terms from Taxonomy

SELECT a.name as term_name, wp_term_taxonomy.term_id
	FROM wp_term_taxonomy
		JOIN
			wp_terms a
			ON (wp_term_taxonomy.term_id = a.term_id)
		LEFT JOIN
			wp_terms b
			ON (wp_term_taxonomy.parent = b.term_id)
	WHERE wp_term_taxonomy.taxonomy = 'newscategory'
	GROUP BY wp_term_taxonomy.term_id