In order to be succeed,I work hard

这不是从句,但是是做状语.in order to是个短语,意思是“为了.”,相当于介词,但后面要加不定式,即动词原形,表示目的.
从句是要有完整句子成分的,如果用in order that...那就是状语从句了.In order that I can be successful,I work hard.这里I can be successful是个完整句子,因此是由in order that 引导的状语从句.
你的原句有语法错误,succeed是动词,形容词应该是successful,正确说法是：
In order to succeed,I work hard.
或 In order to be successful,I work hard.